Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

OCF w / o Engine & Control System Operating Cashflow Yr 0 Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr

OCF w/o Engine & Control System
Operating Cashflow Yr 0 Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7 Yr 8 Yr 9 Yr 10 Yr 11 Yr 12
Revnues $0.00 $1,400,000.00 $1,435,000.00 $1,470,875.00 $1,507,646.88 $1,545,338.05 $1,583,971.50 $1,623,570.79 $1,664,160.06 $1,705,764.06 $1,748,408.16 $1,792,118.36 $0.00
Gain on Disposal $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200,000.00
Less Cash Expenses -$820,000.00-$1,181,000.00-$1,210,525.00-$1,240,788.13-$1,271,807.83-$1,303,603.02-$1,369,597.93-$1,369,597.93-$1,403,837.88-$1,438,933.82-$1,474,907.17-$1,511,779.85 $0.00
Less tax on Gain of Disposal $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00-$12,600.00
Less Tax $172,200.00-$45,990.00-$47,139.75-$48,318.24-$49,526.20-$50,764.35-$45,018.45-$53,334.30-$54,667.66-$56,034.35-$57,435.21-$58,871.09 $0.00
-$647,800.00 $173,010.00 $177,335.25 $181,768.63 $186,312.85 $190,970.67 $169,355.12 $200,638.56 $205,654.52 $210,795.89 $216,065.78 $221,467.43 $187,400.00
Present Value of Future Cashflows $1,227,520.83 $155,864.86 $143,929.27 $132,907.66 $122,730.04 $113,331.80 $90,544.16 $96,639.25 $89,238.95 $82,405.33 $76,095.01 $70,267.92 $53,566.57
NPV $579,720.83
IRR 27%
OCF w Engine & Control System
Operating Cashflow Yr 0 Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Yr 6 Yr 7 Yr 8 Yr 9 Yr 10 Yr 11 Yr 12
Revenues $0.00 $1,400,000.00 $1,435,000.00 $1,470,875.00 $1,507,646.88 $1,545,338.05 $1,583,971.50 $1,623,570.79 $1,664,160.06 $1,705,764.06 $1,748,408.16 $1,792,118.36 $0.00
Gain on Disposal $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200,000.00
Less Cash Expenses -$1,420,000.00-$1,020,000.00-$1,045,500.00-$1,071,637.50-$1,098,428.44-$1,125,889.15-$1,154,036.38-$1,182,887.29-$1,212,459.47-$1,242,770.96-$1,273,840.23-$1,305,686.24 $0.00
Less tax on Gain of Disposal $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00-$12,600.00
Less Tax $298,200.00-$79,800.00-$81,795.00-$83,839.88-$85,935.87-$88,084.27-$90,286.38-$92,543.53-$94,857.12-$97,228.55-$99,659.27-$102,150.75 $0.00
-$1,121,800.00 $300,200.00 $307,70

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

Step: 3

blur-text-image

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

Principles Of Finance

Authors: Scott Besley, Eugene F. Brigham

3rd Edition

0324232624, 9780324232622

More Books

Students also viewed these Finance questions

Question

=+What kind of design would this be? Diagram the experiment.

Answered: 1 week ago