Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help figure out if this pro forma or cash flow statement thank you! .1 .2 .3 .4 .5 .6 .8 .9 '5 '6

can you help figure out if this pro forma or cash flow statement thank you!
image text in transcribed

.1 .2 .3 .4 .5 .6 .8 .9 '5 '6 11 12 Year Sales 25% Revenue reduction Food & Beverages Cost Gross profit Expense Other expense repair & Maintance Depreciation Total expense EBIT Tax ( 30% of income) Net income After Tax add: depreication operating cash flow Caital Expenditure Cash Flow Discount Rate PV Factors NPV WACC PV Factors NPV Balance Payback Payback period 0.25 0.22 0.05 10.75% (2,100,000) 2100000 (2,100,000) -2,100,000 1,950,054 (2,100,000) 1,265,602 2,100,000 3.59 1 4,672,000 (1,650,000) 1,854,000 1,027,840 10,000 350,000 1,387,840 466,160 (139,848) 326,312 350,000 676,312 (350,000) 326,312 0.952 644,107 0.903 610,665 1,489,335 2 4,905,600 (1,683,000) (1,226,400) 1,996,200 1,079,232 10,000 350,000 1,439,232 556,968 (167,090) 389,878 350,000 739,878 (350,000) 389,878 0.907 671,091 0.815 603,215 886,119.15 3 5,150,880 (1,767,125) (1,287,720) 2,096,035 1,133,194 10,000 350,000 1,493,194 602,841 (180,852) 421,989 350,000 771,989 (350,000) 421,989 0.864 66673 0.736 568,303 317,816.22 4 5,408,424 (155,500) (1,352,106) 2,200,818 1,189,853 10,000 350,000 1,549,853 650,965 (195,289) 455,675 350,000 805,675 (350,000) 455,675 0.823 662,831 0.665 535,532 5 5,67845 (1,892,500) (1,419,711) 2,366,634 1,249,346 10,000 350,000 1,609,346 757,288 (227,186) 530,101 350,000 880,101 (350,000) 530,101 0.784 689,583 0.600 528,219 5,962,787 (1,930,375) (1,490,697) 2,541,715 1,311,813 10,000 350,000 1,671,813 869,902 (260,971) 608,931 350,000 958,931 (350,000) 608,931 0.746 715,569 0.542 519,667

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Management

Authors: Jeff Madura, Roland Fox

5th Edition

1473770505, 978-1473770508

More Books

Students also viewed these Finance questions

Question

What risks come with the reliance on authority for knowledge?

Answered: 1 week ago