I have a finance class final paper, I believe I can complete the paper myself, but I need your help to do those calculation by using excel spreadsheet. Plus few sentences to explain the required questions(6 of them)<br>
my request consist two parts<br>
1, calculate financial factors on Excel spreadsheet, all data will be giving under “ASSESSMENT INSTRUMENT ” No outside resources needed<br>
<br>
o Operating Cash Flows <br>
o Incremental Cash Flows, including investment and salvage <br>
o Warranty costs <br>
o WACC <br>
o NPV, IRR, Payback, and Profitability Index<br>
<br>
2, Several sentences to explain following questions based on the calculation result <br>
<br>
1) How much importance should be given to the energy cost situation? <br>
2) What are the project’s cash flows for the next twenty years? What assumptions <br>
did you use? <br>
3) What is the company’s cost of capital? What is the appropriate discount factor <br>
(which may be different) for you to use in evaluating the bus project? <br>
4) If you decide to go ahead with the project, which of the two engines should be <br>
used in the bus, and why? <br>
5) Evaluate the quality of the project, by using appropriate capital budgeting <br>
techniques. <br>
6) Would you recommend that Shrieves Transportation Company accept or reject the <br>
project? What are the key factors on which you base your recommendation? <br>
<br>
I will upload three additional materials to help you finish the job, but you do not need complete the whole paper(which requires at least 6 pages). I only need you to finish the calculation part and briefly explain those 6 questions for me.<br>
<br>
Thank you so much!