Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I added some of the excel sheet The Net Present Value is calculated below with 5.75% Cost of Capital: Year 3 5 6 Total Acquisition

I added some of the excel sheet

image text in transcribed
The Net Present Value is calculated below with 5.75% Cost of Capital: Year 3 5 6 Total Acquisition Stage Cash Flow -1,205,000.00 81.035.46 20,772.51 6.192.04 87,829.10 -3,927.94 28,096.99 Total Operating Stage Cash Flow 1,103,760.00 2,472,213.78 2,379,455.58 2, 129,760.00 906,737.36 1, 103,667.05 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value of Future Cash Flows at 5.75% $10,430,340.35 Net Present Value The Net Present Value is calculated below with 8.75% Cost of Capital: Year 5 6 Total Acquisition Stage Cash Flow -1,205,000.00 81,035.46 -20,772.51 -6,192.04 87,829.10 -3,927.94 28,096.99 Total Operating Stage Cash Flow 1,103,760.00 2,472,213.78 2,379,455.58 2,129,760.00 906,737.36 1,103,667.05 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value of Future Cash Flows at 8.75% $9,334,958.38 Net Present Value The Net Present Value is calculated below with 11.75% Cost of Capital: Year 5 Total Acquisition Stage Cash Flow -1,205,000.00 81,035.46 -20,772.51 6.192.04 87,829.10 -3,927.94 -28,096.99 Total Operating Stage Cash Flow 1,103,760.00 2,472,213.78 2,379,455.58 2,129,760.00 906,737.36 1,103,667.05 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value of Future Cash Flows at 11.75% $8,409,468.24 Payback Period Year 3 5 6 Cash Flows -1,205,000.00 1022724.54 2451441.27 2373263.54 2217589.1 902809.42 1075570.06 Accumulated cash flow -1,205,000.00 -182,275.46 2,269,165.81 4,642,429.35 6,860,018.45 7,762,827.87 8,838,397.93 Payback period 1.074354406 1.07 years Present Value Payback Period Year 5 Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value each year $1,205,000.00 $946,967.17 $4,371,568.79 $6, 116,130.32 $7,344,936.38 $3,604,656.23 $4,972,230.96 Accumulated present value -1,205,000.00 -$258,032.83 $4,113,535.96 $10,229,666.28 $17,574,602.66 $21,179,258.89 $26,151,489.85

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Calculus

Authors: James Stewart

6th Edition

0495011606, 978-0495011606

Students also viewed these Accounting questions

Question

Explain the relationship between thoughts, feelings, and actions.

Answered: 1 week ago