Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
Topic: You are the new financial assistant to the mayor of the City of Los Angel
Topic: You are the new financial assistant to the mayor of the City of Los Angeles, and need to advise the Mayor on some proposed capital investment projects. The three current projects under consideration are:
Project A: Build Toll Road
Initial Investment: $50 million
CF1 = $150 million
CF2 = $25 million
Note: CF = “Cash Flow”, so, for example, “CF1” means cash flow occurring at the end of Year 1.
Project B: Build Baseball Stadium
Initial Investment: $25 million
CF1 = $35 million
CF2 = $100 million
Project C: Build Airport
Initial Investment: $20 million
CF1 = $25 million
CF2 = $35 million
Assignment: Based on NPV, profitability index, and payback analysis, which project or projects do you approve? Unfortunately, however, due to a slow economy, you are limited to spending no more than $50 million. Additionally, the city uses a 10% discount rate when evaluating capital projects.
Please show your quantitative calculations via an Excel spreadsheet or other spreadsheet method in an easy-to-read data table like this:
NPV ProfIndex Payback Accept/Reject? Reason?
Project A
Project B
Project C
Then, below the data table, please write a brief (100-200 word) memo to the mayor summarizing your findings and making a recommendation regarding which projects to accept or reject
Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.