Business Finance Class

profilerufgato30
BUS_330_Group_Project_Example_Excel.xlsx
Home>Business & Finance homework help>Management homework help>Business Finance Class

CF Analysis

MARCUS ENGINE Year Year Year Year Year Year Year Year Year Year Year Year Year Year Year Year Year Year Year
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
OPERATING SUMMARY
Price per bus
Units sold
Revenue ($000)
Expenses ($000)
Labor @ $32,500/unit
Parts @ $86,500/unit
Engine (Marcus) @ $17,500/unit
Gross Profit ($000)
Sales/Administration
Bus Warranty per unit
Depreciation
EBIT ($000)
Taxes @
NOPAT ($000)
Operating Cash Flow ($000) NOPAT+Depreciation
INVESTMENT SUMMARY
Incremental Cash Flow ($000) --->
Net Present Value ($000) @
Internal Rate of Return

warranty costs

COST OF NO. OF PRESENT Purchase Price Total Cost
PMT CAPITAL YEARS VALUE
Bus Warranty 2000 WACC 5 ERROR:#VALUE!
Marcus Engine 1350 WACC 5 ERROR:#VALUE! 17500 ERROR:#VALUE!
Detroit Engine 1250 WACC 5 ERROR:#VALUE! 18500 ERROR:#VALUE!
Detroit engines Marcus engines
$18,500 $17,500
$1,250 $1,350

WACC