Do the numbers in the projection include inflation

Assignment Help Finance Basics
Reference no: EM131420314

Assignment

1. The preliminary engineering cost of GBP500,000 that has already been spent on efficiency and design studies for the renovation is included on the projection for the project (in Assumptions it is included in Preliminary Engineering Costs). Should it be included? Why or why not? If not, change the projection to reflect this.

2. From page 70 of your textbook: "the corporate manual stipulated that overhead costs be reflected in the project analyses at the rate of 3.5% times the book value of assets acquired in the project per year." This cost is included in the Assumptions of the project under the title of "Overhead/Investment". Investopedia has a definition of overhead at this link: https://www.investopedia.com/terms/o/overhead.asp. The proposed project is largely a renovation project that only increases production by 7%. Should you include the 3.5% charge on the projection? Should you only include a portion of it or none at all? Explain your answer. If you think that it is inappropriate to charge the 3.5% on the project, adjust the assumption on the projection.

3. Pages 70 and 71 in your textbook describe concerns of the Transport Division that as a result of accepting the project the division would need to invest in new rolling stock earlier than anticipated. Greystock argues against it in the case. Do you agree with Greystock that the cost of the new rolling stock shouldn't be included or do you agree with the Transport Division that the cost of the new rolling stock cost of the rolling stock (GBP2 million) should be included in the initial outlay on the proposed Merseyside project? Is there a different alternative that should be investigated? (Hint: consider what the incremental cash flows are). Don't make any changes to the spreadsheet for this question.

4. On page 72, Greystock stated that "cannibalization really isn't a cash flow" and didn't include a possible decrease in sales from the Rotterdam plant in the estimated project cash flows for Merseyside. Do you agree with this statement and his decision not to include the possible decrease in sales at Rotterdam in the cash flows for the project? Why or why not? Don't make any changes to the spreadsheet for this question.

5. On page 72, Griffin Tewitt requests an adjustment to the Merseyside proposal. He would like the cash flows of the renovation (including the initial investment) to be added to the Merseyside proposal. Do you agree with his request? Why or why not? Don't make any changes to the spreadsheet for this question.

6. Page 73 provides concerns of the Treasury Staff that WACC (the discount rate) includes the expected rate of inflation at 3% per year. Do the numbers in the projection (revenues, expenses, and cash flows) include inflation? Should they? If you think that they should, adjust the inflation assumption in the assumptions area.

7. After changing the assumptions in the projection based on your answers above, what are the NPV, IRR, MIRR, Profitability Index, and Payback Period of the project? Based on criteria numbers 2 through 4, is this project acceptable? Would you accept this project?

Attachment:- merseyside_projection.xlsx

Reference no: EM131420314

Questions Cloud

Important changes that occurred in western europe : List the four most important changes that occurred in Western Europe from 1945-1989 and explain why they were so significant and what from worlkd war II most impacted society after 1945?
Most important changes that occurred in western europe : List the four most important changes that occurred in Western Europe from 1945-1989 and explain why they were so significant and what from worlkd war II most impacted society after 1945?
Rental agreement : American Car Rental (ACR), at the top of its rental agreement, stated, "Vehicles driven in excess of 79 miles per hour will be charged $150 fee per occurrence. All our vehicles are GPS equipped. It charged customers the fee every time the GPS showed ..
Problem regarding the progressive movement : What was the common issue that not only created the "evils' of society but led to moral decay as believed by the Progressive movement? And how did the Progressive politicians remove it from American life?
Do the numbers in the projection include inflation : Page 73 provides concerns of the Treasury Staff that WACC (the discount rate) includes the expected rate of inflation at 3% per year. Do the numbers in the projection (revenues, expenses, and cash flows) include inflation?
Generating tax revenue as do tariffs-require tax revenue : Rather than generating tax revenue as do tariffs, subsidies require tax revenue. Therefore, they are not an effective protective device for the home economy. Do you agree? What would be the likely effects of export restraints imposed by Japan on its ..
Discuss the effects of the innovation on your field : Organize your report into sections that have headings that give the reader a good sense of the dimensions of the topic and the outline. Information you might present includes: Effects of the innovation on your field and on the industry in general
Effect on human rights compliance : how is the correlation between ratification of the European Convention of Human Rights and countries Compliance rate and That is to investigate whether raritication of the ECHR (47 member states) affect the level of political terror, compared with a..
Find the punch and die sizes for the blanking operation : A compound die will be used to blank and punch a large washer out of 6061ST aluminum alloy sheet stock 3.50 mm thick. The outside diameter of the washer is 50.0 mm and the inside diameter is 15.0 mm.

Reviews

Write a Review

Finance Basics Questions & Answers

  List the three key features of the financial system

Consider the possibility of income insurance. With income insurance, if a person loses his job or doesn't get as big a raise as anticipated, he would be compensated under his insurance coverage. Why don't insurance companies offer income insurance..

  Justify your decision in recommending the stock

Based on these factors, what stock would you recommend to the client. What reasons will you convey to your client to justify your decision in recommending this stock. How will this recommendation impact the client

  Common stock and preferred stock

What are the similarities, and what are the differences, between common stock and preferred stock?

  What maximum growth rate can abbai achieve

To support its future growth, the firm plans to raise some debt from creditors while keeping its debt-equity ratio unchanged. What maximum growth rate can Abbai achieve?

  What are the pros and cons of the international sales plan

Taking all factors into account, should the company pursue international sales further? Why or why not?

  What will be her capital gain from holding the bond

If market conditions do not change--that is market interest rates remain constant--and Stephanie sells the bond in 12 months, what will be her capital gain from holding the bond?

  Bell mountain vineyards is considering updating its current

1archer daniels midland company is considering buying a new farm that it plans to operate for 10 years. the farm will

  Should the investor purchase abc

Given that ABC stock has a required or expected rate of return of 15%, the average market return is 11% and the interest yield on 10-year US Treasury Bonds is 4%, should the investor purchase ABC? Show your work to explain why or why not.

  The markup on a home spa should be 20 based on selling

the markup on a home spa should be 20 based on selling price. if the seller paid 5900 for one then how much should it

  Define the following terms as they apply to our work in fin

refer to the text page 59710th edition to answer q1 and q2. answer length for each question one-half to one-page single

  A stock is currently priced at 26 a share while the 30 put

a stock is currently priced at 26 a share while the 30 put option is priced at 5.22. the put option delta is -.25 what

  What is the required return

The next dividend payment from a firm will be $1.12 per share. The dividends are anticipated to maintain a 5% growth rate for ever. If the firm shares currently sell for $35.00, what is the required return?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd