Answered step by step
Verified Expert Solution
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,
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started