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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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