Question

In: Accounting

All analysis should be done in MS Excel, and a memo to your boss explaining the...

All analysis should be done in MS Excel, and a memo to your boss explaining the situation, your

analysis, and conclusion should be prepared in MS Word. You must upload both files to be graded.

You will only get full credit for the assignment if your analysis is correct, all calculations and/or formulas

use cell references, and your memo has the right content, flows well, and is properly formatted, and

grammatically correct. An example of a good memo, and an Excel template is provided for your benefit.

You can add or delete columns in the excel template as needed.

Playtan Corporation has a machine that either should be repaired or should be replaced soon.

You have recently been hired by Playtan and one of your assignments is to help decide whether

replacing the machine, or repairing it is in the best interest of your company.

Investment required for repairing the machine is only $500,000 and cost to replace the machine

is $3,000,000. Repairing the machine will cut down on the number of returns from customers

and increase cash flows, while replacing the machine may increase the number of units sold.

Playtan has evaluated and calculated additional cash flows that will be generated under the two

scenarios over the next five years as follows:

Year

Cash flow (if repaired)

Cash Flow (if replaced)

1

197,000

1,613,000

2

160,000

1,185,000

3

178,000

978,100

4

139,000

997,800

5

117,000

990,000

Playtan does not accept projects that will pay back in more than 3 years, or any projects that will not

maximize shareholder wealth. So, you will need to use all capital budgeting techniques you’ve learnt in

your Finance class to ensure that the right option is chosen.

Cost of capital for the project (repair or replacement) could be anywhere from 8% to 14%, so you will

conduct your analyses at various weighted average cost of capital (WACC) or Required rate of return

points including at least five at 8%, 9%, 11%, 13%, and 14% for both scenarios, and also draw an NPV

profile for both situation using your calculations.

Use your knowledge of capital budgeting and time value of money to decide which of the options is better

for Playtan. All analysis must be done in Excel. Your excel model should be such that it can be used by

Playtan or any other corporation for similar capital budgeting situations – so anyone can change any

numbers and use the model again. This would require all calculations to be using cell references and excel

functions. You must write a memo to your boss, explaining the situation, your analysis, and your

conclusion. You must also explain the drawbacks of your technique/s if there are any.

Make sure that all your submissions have your full name, class, and section number included.

Solutions

Expert Solution

Discount % 8%
9%
11%
13%
14%
To repair
Year 0 1 2 3 4 5
PV of outflow ($500,000)
Cash inflows $197,000 $160,000 $178,000 $139,000 $117,000
Net inflows ($500,000) $197,000 $160,000 $178,000 $139,000 $117,000
NPV@8% $132,112
NPV@9% $116,848
NPV@11% $88,727
NPV@13% $63,502
NPV@14% $51,870
Payback 2 years 9 Months & 19 days
To replace
Year 0 1 2 3 4 5
PV of outflow ($3,000,000)
Cash inflows $1,613,000 $1,185,000 $978,100 $997,800 $990,000
Net inflows ($3,000,000) $1,613,000 $1,185,000 $978,100 $997,800 $990,000
NPV@8% $1,567,687
NPV@9% $1,452,091
NPV@11% $1,238,651
NPV@13% $1,046,581
NPV@14% $957,784
Payback 2 years 2 Months & 14 days

Based on the above calculation is it better to replace the machine which gives higher cash flows as compared to reparing the machine

Even the NPV is way much higher for replacing the machine than repairing the machine. So management must go for repairing the machine.

Note: tax impact and depreciation is excluded in the above calculation


Related Solutions

The Ratio Calculations should be done in a table in Excel and included with your submission....
The Ratio Calculations should be done in a table in Excel and included with your submission. The following ratios should be included for Pier 1 for 2 years: calculate these ratios below is a link to 10-K form Working Capital Current Ratio Total Debt to Total Equity Ratio Times Interest Earned RNOA ROCE Show calculations for pier 1 https://investors.pier1.com/financial-information/annual-reports
Question: a) Write a one page memo to your boss proposing to sponsor or partner with...
Question: a) Write a one page memo to your boss proposing to sponsor or partner with a non-profit or a cause. b) Write out three questions "the Boss" would likely ask you about your proposal. (Note that, I want this answer to be unique and not similar to others in terms of writing. thanks)
Write an ONE-page memo to your boss regarding your views on Autonomous vehicles and how they...
Write an ONE-page memo to your boss regarding your views on Autonomous vehicles and how they can be useful to an employee or your (imaginary) company!
As a financial adviser to individual investors, your boss has asked you to write a memo...
As a financial adviser to individual investors, your boss has asked you to write a memo to him so that he can recommend a mortgage-backed bond to a client. The client has a particular corporate bond in mind, but your boss thinks that a pass-through mortgage-backed security would provide a better yield at the same risk level and maturity. The bond that the client is considering is a 7-year, AA-rated bond with a 6.75% coupon. When it matures, the proceeds will be...
As a financial adviser to individual investors, your boss has asked you to write a memo...
As a financial adviser to individual investors, your boss has asked you to write a memo to him so that he can recommend a mortgage-backed bond to a client. The client has a particular corporate bond in mind, but your boss thinks that a pass-through mortgage-backed security would provide a better yield at the same risk level and maturity. The bond that the client is considering is a 7-year, AA-rated bond with a 6.75% coupon. When it matures, the proceeds...
Please show all calculations in MS Excel. No credit will be earned unless you show your...
Please show all calculations in MS Excel. No credit will be earned unless you show your calculations. Problem 1: CAPM: 5-Points: If the risk-free rate is 0.0200, the return of the market is 0.1350, and the beta is 1.18, what is the required rate of return of the stock using the CAPM equation? Please note that the return of the market is not the same as the market risk premium. Problem 2: Growth Rate: (Equation 9.11, page 373): 5-Points: If...
A short memo outlining your strategy and initial holdings, and this memo should be typed, one...
A short memo outlining your strategy and initial holdings, and this memo should be typed, one or two pages long and look professional. It should include your investment strategy (including your horizon, which does not have to coincide with the 10-week investment period), and the initial composition of your portfolio, with a concise and general justification (no need to discuss each stock in detail!) The description of your holdings should include the name of each security, number of shares held,...
Please show all your work if you use the Calculator. If done in Excel, please send...
Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon...
This should be done in as an Excel file. Using the simple time value of money...
This should be done in as an Excel file. Using the simple time value of money concepts from Corporate Finance course: Calculate the price of an annual coupon‐bond with a par value of $1,000, time to maturity of 10 years, coupon rate of 10% and yield to maturity of 12% (bond DC). yield to maturity of 8% (bond PC). Do the sensitivity analysis on the price of these two bonds (bond DC & bond PC) by changing the following (one...
Write a memo to your Chief Executive officer Mr Baba Ahmed explaining to him the meaning...
Write a memo to your Chief Executive officer Mr Baba Ahmed explaining to him the meaning of Global Reporting Initiatives and state two examples each of the aspect of each of the dimensions
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT