1. What is the cash payback period on each model (rounded by two decimal places)? Assuming an interest rate of 10 percent, what is the NPV of each model? Briefly explain which machines they should select.
2. You recently purchased a new home for $275,000 by agreeing to make annual payments for 15 years; if the interest rate on your loan is 4 percent, what is the total amount of interest you will pay over the life of the loan?
3. You recently received a birthday gift of $500 and you decide
to save it for later use. If you deposit it into an investment
account that earns 6 percent interest, how much will be in the
account in 3 years?
4. You have recently opened a retirement account and decided to
deposit $2500 per year in the account. If you want to retire in 45
years and the account earns 8 percent interest, how much will you
have in your account when you retire>
5. You borrowed $1,200 to buy a new computer and agreed to pay the
loan back 3 years later; if the loan has a 10 percent interest
rate, what is the balance you will owe at that time?
6. You recently purchased a new car for $18,000 by agreeing to make equal annual payments for 5 years. If the interest rate on your loan is 8 percent, how much is each payment?
7. In 2 years, you will need $800 for a trip you planned to Costa Rica. If your account earns 4 percent interest, how much should you deposit today to reach your goal?
Model DQT | Model Mk6 | |||||||
a | Purchase Cost | 18,000 | 26,000 | |||||
Estimated cash inflows | ||||||||
b | Year 1 | 9,000 | 12,000 | |||||
c | Year 2 | 7,000 | 10,000 | |||||
d | Year 3 | 5,000 | 9,000 | |||||
e | Year 4 | 4,000 | 6,000 | |||||
f | Pay beck period | Years untill full recovery + Balance recoverable amount /cash flow during that year | ||||||
g | Amount recoverable in two years (a+b) | 16,000 | 22,000 | |||||
h | Balance recoverable (a-g) | 2,000 | 4,000 | |||||
i | Third year cashflow | 5,000 | 9,000 | |||||
j | Payback period =2+h/i | 2 | 2 | |||||
1.a | Calculation of NPV | Year 1 | Year 2 | Year 3 | Year 4 | Total Inflow | Total Outflow | NPV |
k | Present value factor (10% (1/1.1)^n | 0.91 | 0.83 | 0.75 | 0.68 | |||
l | Model DQT | 9,000 | 7,000 | 5,000 | 4,000 | |||
m | Present value (k*l) | 8,182 | 5,785 | 3,757 | 2,732 | 20,456 | 18,000 | 2,456 |
n | Model Mk6 | 12,000 | 10,000 | 9,000 | 6,000 | |||
o | Present value (k*n) | 10,909 | 8,264 | 6,762 | 4,098 | 30,033 | 26,000 | 4,033 |
Though the model DQT has little bit of faster payback period it is preferable to chose model Mk6 because higher NPV | ||||||||
2 | Computation of interest | Amount in $ | ||||||
a | Loan Amount | 275,000.00 | ||||||
b | Term | 15 Years | ||||||
c | Interest rate | 0.04 | ||||||
d | Assuming equated annual instalment | P*r*((1+r)^n)/((1+r)^n-1)) | ||||||
e | (1+r)^n (r=rate, n=term) | 1.80 | ||||||
f | (1+r)^n-1 | 0.80 | ||||||
g | Instalment (a*b*(e/f) | 24,733.80 | ||||||
h | Total Instalements (g*15) | 371,007.04 | ||||||
i | Interest amount (h-a) | 96,007.04 | ||||||
3 | Future value of deposit | Amount in $ | ||||||
a | Initial deposit | 500 | ||||||
b | 6% Annuity value for three years (1+0.6)+(1.06)^2+(1.06)^3 | 3.374616 | ||||||
c | Gift value in bank account after three years a*b | 1687.308 | ||||||
4 | Future value after 45 years by depositing monthly | |||||||
a | Future value annuity factor for 8% is F = P * ([1 + I]^N - 1 )/I. | |||||||
b | Yearly Payment (P) | $2,500 | ||||||
c | Years (N) | 45 | ||||||
d | Rate (I) | 8% | ||||||
e | Future value | $966,264.04 |
Request you to throw an another question for rest of the parts of question unanswered. Please note that the answer was too long and hence as per policies four parts of the question has been answered. Kindly post another question for the unanswered parts.
1. What is the cash payback period on each model (rounded by two decimal places)? Assuming...
Speedy Delivery Company is considering two different machines for use in its sorting facility and the company's management put together the following cash flow estimates: 5 NO ACC 310F, Group Assignment November 21, 2019 Group Members You must have between 3-5 group members per team List alphabetically by last name: last name, first name For all time value of money calculations, use time value of money factors with at least 4 decimal places and do not round intermediate calculations, instead,...
Answer each of the following questions, which are independent from each other. For all time value of money calculations, use time value of money factors with at least 4 decimal places and do not round intermediate calculations; instead, only round your final answer to the nearest whole number. Speedy Delivery Company is considering two different machines for use in its sorting facility and the company's management put together the following cash flow estimates: Model DQT Model MK6 Purchase cost 18,000...
1. You recently received a birthday gift of $500 and you decide to save it for later use. If you deposit it into an investment account that earns 6 percent interest, how much will be in the account in 3 years? 2. You borrowed $1,200 to buy a new computer and agreed to pay the loan back 3 years later; if the loan has a 10 percent interest rate, what is the balance you will owe at that time? 3....
A. You recently purchased a new home for $275,000 by agreeing to make annual payments for 15 years; if the interest rate on your loan is 4 percent, what is the total amount of interest you will pay over the life of the loan? B. You have recently opened a retirement account and decided to deposit $2,500 per year in the account. If you want to retire in 45 years and the account earns 8 percent interest, how much will...
Answer each of the following questions, which are independent from each other. For all time value of money calculations, use time value of money factors with at least 4 decimal places and do not round intermediate calculations; instead, only round your final answer to the nearest whole number. 1. What is the cash payback period on Model DQT (rounded to two decimal places)? 2. What is the cash payback period on Model MK6 (rounded to two decimal places)? 3. What...
You borrowed $1,200 to buy a new computer and agreed to pay the loan back 3 years later; if the loan has a 10 percent interest rate, what is the balance you will owe at that time? You recently purchased a new car for 18,000 by agreeing to make equal annual payments for 5 years. If the interest rate on your loan is 8 percent, how much is each payment?
You want to be able to withdraw $40,000 from your account each year for 30 years after you retire. If you expect to retire in 25 years and your account earns 5.6% interest while saving for retirement and 4.1% interest while retired: Round your answers to the nearest cent as needed. a) How much will you need to have when you retire? b) How much will you need to deposit each month until retirement to achieve your retirement goals? c)...
You want to be able to withdraw $20,000 from your account each year for 30 years after you retire. You expect to retire in 25 years. If your account earns 10% interest, how much will you need to deposit each year until retirement to achieve your retirement goals?
You want to be able to withdraw $35,000 from your account each year for 15 years after you retire. If you expect to retire in 25 your account earns 6.2% interest while saving for retirement and 5.4% interest while retired: and years Round your answers to the nearest cent as needed. a) How much will you need to have when retire? you S b) How much will you need to deposit each month until retirement to achieve your retirement goals?...
You want to be able to withdraw $45,000 from your account each year for 30 years after you retire. If you expect to retire in 15 years and your account earns 7.7% interest while saving for retirement and 7.5% Interest while retired: Round your answers to the nearest cent as needed. *) How much will you need to have when you retire? b) How much will you need to deposit each month until retirement to achieve your retirement goals? How...