Question

In: Economics

Presuming you will make a $500,000 dollar investment into your firm. The machine that you purchased...

Presuming you will make a $500,000 dollar investment into your firm. The machine that you purchased has a life span of 6 years. At the end of 6 years there will be no residual value left to the machine. If the machine will generate $145,000 annually what is your internal rate of return.

Recalculate your Internal Rate of return if the initial investment is $800,000 and investment will generate the following annual revenue.

Year 1   $150,000

Year 2   $125,000

Year 3   $175,000

Year 4   $150,000

Year 5   $120,000

Year 6   $100,000

Please do the calculations through excel.

If the financial institution charges you 4.2% interest should you make the investment? If you are making 1 payment annually during the 6 years what is your annual payment at an interest rate of 4.2%?

Solutions

Expert Solution

We will use IRR function in excel to calculate ROR in excel

Years Cash flow
0 -500000
1 145000
2 145000
3 145000
4 145000
5 145000
6 145000
IRR 18.6%
Years Cash flow
0 -800000
1 150000
2 125000
3 175000
4 150000
5 120000
6 100000
IRR 0.7%

If financial institutions charge 4.2% interest rate then we should make the investment in the first case as ROR is greater than the interest rate and we should not make the investment in the second case as ROR is less than the interest rate.

We will use PMT function in excel to calculate annual payment.

investment 500000
tenure 6
interest rate 4.20%
Annual payment 96,002.89
investment 800000
tenure 6
interest rate 4.20%
Annual payment

1,53,604.62

Showing formula in excel

Years Cash flow
0 -500000
1 145000
2 145000
3 145000
4 145000
5 145000
6 145000
IRR =IRR(B2:B8)
Years Cash flow
0 -800000
1 150000
2 125000
3 175000
4 150000
5 120000
6 100000
IRR =IRR(B12:B18)
investment 500000
tenure 6
interest rate 0.042
Annual payment =PMT(B23,B22,-B21)
investment 800000
tenure 6
interest rate 0.042
Annual payment =PMT(B28,B27,-B26)

Rahul Sunny answered 2 months ago
Next > < Previous

Related Solutions

1) You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year...
1) You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year MACRS. This machine generates $200,000 in annual revenue. In year 4, you sold the machine for $250,000. You received a loan for $400,000 on a 5 year loan at 5% (note, you must pay the remaining balance of this loan at the end of year 4 from the proceeds of the sale). In addition, you invested $80,000 in working capital initially. Your company is...
You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year MACRS....
You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year MACRS. This machine generates $200,000 in annual revenue. In year 4, you sold the machine for $250,000. You received a loan for $400,000 on a 5 year loan at 5% (note, you must pay the remaining balance of this loan at the end of year 4 from the proceeds of the sale). In addition, you invested $80,000 in working capital initially. Your company is in...
Your firm will either purchase or lease a new $500,000 packaging machine from the manufacturer. If...
Your firm will either purchase or lease a new $500,000 packaging machine from the manufacturer. If purchased, the machine will be depreciated straight-line over five years. You can lease the machine using a true tax lease for $125,000 per year for five years with the first payment today. Assume the machine has no residual value, the secured borrowing rate is 9%, and the tax rate is 35%. Should you buy or lease?
Mags Ltd. has purchased a new machine for a cost of $500,000. The machine has just...
Mags Ltd. has purchased a new machine for a cost of $500,000. The machine has just been installed and the cost of installation is $30,000. The internal auditors have advised that the cost of installation cannot be depreciated. The machine’s suppliers have requested a 20% deposit on installation with the remainder to be paid within six months. The current estimated before-tax net operating cash revenue for the coming four years are $300,000 in the first year, $320,000 in the second...
Your firm needs a $725,000 machine. If purchased, the machine will be depreciated straight-line over seven...
Your firm needs a $725,000 machine. If purchased, the machine will be depreciated straight-line over seven years and is expected to have a residual value of $25,000 at the end of the seventh year. Your (pre-tax) cost of borrowing is 6.5% and tax rate is 21%. If this is a non-tax lease, with beginning of year payments, what is the maximum lease payment for which you would prefer the lease to the alternative of borrowing money to buy the machine?
your aunt comes to you with an investment opportunity. She needs you to invest $500,000. If...
your aunt comes to you with an investment opportunity. She needs you to invest $500,000. If the investment succeed, it will pay you back your investment plus an additional $2 million. If it fails you get nothing back. She thinks there is a 30% chance of success. a. what is the expected value of the investment? b. what is the most likely outcome?
your aunt comes to you with an investment opportunity. She needs you to invest $500,000. If...
your aunt comes to you with an investment opportunity. She needs you to invest $500,000. If the investment succeed, it will pay you back your investment plus an additional $2 million. If it fails you get nothing back. She thinks there is a 30% chance of success. a. what is the expected value of the investment? b. what is the most likely outcome?
You have purchased a canning machine for $5,000. You expect the machine to save your company...
You have purchased a canning machine for $5,000. You expect the machine to save your company $1,425 each year for the next 10 years. What is the IRR of the machine?
Complete the following journal entries for PAT Company. 1. An assembly machine was purchased for $500,000,...
Complete the following journal entries for PAT Company. 1. An assembly machine was purchased for $500,000, shipping cost was $10,000, and the company incurred $5,000 installation cost and $3,000 in testing cost. The company took out a $450,000 15 year 8 percent note payable and paid the balance in cash. 2. PAT Company paid $7,500 in routine maintenance costs. 3. Improvements of $10,000 were paid on an old machine which extended its useful flie. 4. Monthly depreciation of $8000 was...
KOL Limited purchased a machine on 1 January 2018 at $500,000. It has an expected useful...
KOL Limited purchased a machine on 1 January 2018 at $500,000. It has an expected useful life of 5 years and an estimated salvage value of $50,000. It is also expected that the machine can run for 30,000 hours. For the year ended 31 December 2018, KOL has used the machine for 4,000 hours. KOL has another equipment with the following data on 31 December 2018. Cost $260,000 Carrying amount $200,000 Fair value less costs to sell $180,000 Value-in-use $175,000...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT