Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please upload an excel file work out the below project cash flow analysis and clearly layout answers in the excel file. For the eight questions,

image text in transcribed

Please upload an excel file work out the below project cash flow analysis and clearly layout answers in the excel file. For the eight questions, each worth one point, please highlight the cell containing the answers. Then please also clearly state the answer for each question and reference the cell. e.g., "1. The total project cash flow at year o is - $500,000 as shown in cell B20." Considering project that costs $644,000 in capital investment, has an eight-year life, and has no salvage value. Assume that deprecation is straight-line to zero over the life of the project. Sales are projected at 70,000 units per year. Price per unit is $37, variable cost per unit is $21, and fixed costs are $797,500 per year. Net working capital is estimated to be 10% of sales. The tax rate is 21% and we require a 15 percent return on this project. Please work out the below answers, 1 point each. 1. What's the total project cash flow at year 0? 2. What's the total project cash flow at year 1? 3. What' the total project cash flow at year 8? 4. What' the project NPV? 5. What's the project IRR? 6. What's the accounting break-even point level of sales? 7. What's the NPV break-even point level of sales? 8. If the company has an option to end the project after six years and sell the equipment for $250,000. Calculate the NPV of the project under the six-year life option

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

Students also viewed these Finance questions

Question

Under what conditions is demand price elastic or price inelastic?

Answered: 1 week ago