Question: include excel formulas for the missing answers please $ $ Estimated annual sales Costs Tax rate Project and asset life Required return 2,190,000 815,000 21%

include excel formulas for the missing answers please
include excel formulas for the missing answers please $ $ Estimated annual
sales Costs Tax rate Project and asset life Required return 2,190,000 815,000

$ $ Estimated annual sales Costs Tax rate Project and asset life Required return 2,190,000 815,000 21% 3 12% Complete the following analysis. Do not hard code values in your c $ CA Sales Costs Depreciation EBT Taxes Net income 2,190,000 815,000 966,667 408,333 85,750 322,583 $ $ OCF $ 1,289,250 NPV $ Projected sales Variable cost (% of sales) Fixed cost $ Depreciation $ Tax rate 635,000 44% 193,000 54,000 21% Complete the following analysis. Do not hard code values in y $ Sales Variable costs Fixed costs Depreciation EBT Taxes Net Income 635,000 279,400 193,000 54,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!