Question

In: Finance

Can someone please advise how to solve this problem step-by-step on a calculator? Thanks! Option to...

Can someone please advise how to solve this problem step-by-step on a calculator? Thanks!

Option to wait. Your company is deciding whether to invest in a new machine. The new machine will increase cash flow by $435,000 per year. You believe the new technology used in the machine has a 10 year life. Obsolete 10 years from today. Machine is currently priced at 2.8 Million. Cost of machine will decline $215,000 per year until it reaches $2.155 million, where it will remain. If your required return is 9%, should you purchase the machine? If so, when should you purchase it?

Solutions

Expert Solution

Its a calculation of NPV First we will calculate the NPV using the cost of machine as 2.8 Million. Please find the table below:

Particulars
Cash Outflow -2800000
Cash inflow at Year 1 435000
Cash inflow at Year 2 435000
Cash inflow at Year 3 435000
Cash inflow at Year 4 435000
Cash inflow at Year 5 435000
Cash inflow at Year 6 435000
Cash inflow at Year 7 435000
Cash inflow at Year 8 435000
Cash inflow at Year 9 435000
Cash inflow at Year 10 435000
Cost of capital 9.00%
Present value of cash flows ₹ 26,07,932.40
Net present value of cash flow ₹ -1,92,067.60

If we are using the financial calculator then we need to enter the cash outflow in negative, cash inflow in positive. Also please press enter after every entry of cash outflow/inflow. Then go to NPV calculation insert the interest rate as 9% and press down to net the NPV screen and press compute.

But we are getting the negative NPV which indicates that its not a good decision to invest in the machine in this year. So now we will take it year by year calculation of NPV till the machine reaches 2.155 million.

Year 2-4, when the cost of the machine decreases every year by 215,000

Particulars Year 2
Cash Outflow -2585000
Cash inflow at Year 1 435000
Cash inflow at Year 2 435000
Cash inflow at Year 3 435000
Cash inflow at Year 4 435000
Cash inflow at Year 5 435000
Cash inflow at Year 6 435000
Cash inflow at Year 7 435000
Cash inflow at Year 8 435000
Cash inflow at Year 9 435000
Cash inflow at Year 10 435000
Cost of capital 9.00%
Present value of cash flows ₹ 26,07,932.40
Net present value of cash flow ₹ 22,932.40
Particulars Year 3
Cash Outflow -2370000
Cash inflow at Year 1 435000
Cash inflow at Year 2 435000
Cash inflow at Year 3 435000
Cash inflow at Year 4 435000
Cash inflow at Year 5 435000
Cash inflow at Year 6 435000
Cash inflow at Year 7 435000
Cash inflow at Year 8 435000
Cash inflow at Year 9 435000
Cash inflow at Year 10 435000
Cost of capital 9.00%
Present value of cash flows ₹ 26,07,932.40
Net present value of cash flow ₹ 2,37,932.40
Particulars Year 4
Cash Outflow -2155000
Cash inflow at Year 1 435000
Cash inflow at Year 2 435000
Cash inflow at Year 3 435000
Cash inflow at Year 4 435000
Cash inflow at Year 5 435000
Cash inflow at Year 6 435000
Cash inflow at Year 7 435000
Cash inflow at Year 8 435000
Cash inflow at Year 9 435000
Cash inflow at Year 10 435000
Cost of capital 9.00%
Present value of cash flows ₹ 26,07,932.40
Net present value of cash flow ₹ 4,52,932.40

Looking at the calculation, my suggestion would be to invest in the year 4 when the machine cost reduces to 2.155 million as we will have the maximum NPV then  


Related Solutions

How can I solve this problem? Can you please show step by step how to solve...
How can I solve this problem? Can you please show step by step how to solve this? Qd = 2,000 − 10P MC = 0.1Q
#6 Please Show step by step, so I can solve similar problems, thanks! Give your answer...
#6 Please Show step by step, so I can solve similar problems, thanks! Give your answer as a whole number but do not round your calculations until you get to the final answer. Jole uses the high-low method of estimating costs. Jole had total costs of $12,373 at its lowest level of activity, when 2,597 units were sold. When, at its highest level of activity, sales equaled 6,091 units, total costs were $28,081. Jole would estimate fixed costs as: _______
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
please prove this problem step by step. thanks Prove that in every simple graph there is...
please prove this problem step by step. thanks Prove that in every simple graph there is a path from every vertex of odd degree to some other vertex of odd degree.
*can someone please explain/show me the process of this problem? Thanks in advance! Scott Company uses...
*can someone please explain/show me the process of this problem? Thanks in advance! Scott Company uses an absorption costing system based on standard costs. Total variable manufacturing costs, including direct materials, are $3.00 per unit. The standard production rate is 10 units per machine hour. Total budgeted and actual fixed manufacturing overhead costs are $420,000. Fixed manufacturing overhead is allocated at $6.00 per machine hour ($420,000 / 70,000 machine hours of denominator level). Selling price is $6.00 per unit. Variable...
Please solve and show each step you do to on a financial calculator! 1. A borrower...
Please solve and show each step you do to on a financial calculator! 1. A borrower is evaluating a loan $100,000 with annual rate of interest at 12%. He anticipates making monthly payments of $2,100 then a lump sum payment of $10,000. How long is he expecting to be paying this loan (rounded to the nearest number years / months)? Draw your cash flow diagram and show your steps used in financial calculator. 2. Given the following information about a...
Hello can someone please explain the is lm curves step by step for me?
Hello can someone please explain the is lm curves step by step for me?
Can you please show how you would solve the following using excel? Step by Step? Kaelea,...
Can you please show how you would solve the following using excel? Step by Step? Kaelea, Inc., has no debt outstanding and a total market value of $117,000. Earnings before interest and taxes, EBIT, are projected to be $8,300 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 23 percent higher. If there is a recession, then EBIT will be 32 percent lower. The company is considering a $41,700 debt issue with...
WITH STEP AND HOW YOU SOLVE IT PLEASE ! Max enjoys windsurfing and snorkeling. Max can...
WITH STEP AND HOW YOU SOLVE IT PLEASE ! Max enjoys windsurfing and snorkeling. Max can either rent windsurfing or snorkeling equipment for a fixed price per hour. The table below shows the total utility Max gets from each activity. Max has a budget of 40$ and windsurfing costs 10$ per hour and snorkeling costs 5$ per hour. Calculate Max marginal utility from windsurfing at each number of hours per day and calculate Max’s marginal utility from snorkeling at each...
Please solve this case in Excel,Many thanks! The Problem: You are the technology controller for a...
Please solve this case in Excel,Many thanks! The Problem: You are the technology controller for a mid-sized publicly traded company. You have been assigned to evaluate an investment in a new process that would cost $2.5 million. You have determined that the internal rate of return of the positive operating cash flows associated with the investment is 13.0%. On a market value basis, the firm's capital structure is as follows: Debt: 40%; Preferred Stock: 5%; Common equity: 55%; This capital...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT