Question

In: Finance

A newly divorced father of two, looking to improve his image wants to purchase a Mercedes-Benz...

  1. A newly divorced father of two, looking to improve his image wants to purchase a Mercedes-Benz in order to impress his young and foxy girlfriend. The car costs $17,999 and the car yard is willing to offer financing. The terms of the deal include a $2000 deposit (which the client has) with the remainder of the balance being repaid in equal monthly installments over the next three years. The car dealer charges 1.25 percent interest rate per month on the balance of the outstanding loan.

Required: Calculate the size of each monthly payment and then prepare a loan amortization schedule to show that as time passes the amount paid in interest by your client is reduced.

Solutions

Expert Solution

Here amount to be financed = 17,999 - 2,000 = $15,999

Nper = 3*12 = 36, rate = 1.25%.

The size of each monthly payment = PMT (1.25%, 36, 15999). This gives a value of $554.61

It can also be computed manually using the formula: P*r*(1+r)^n/(1+r)^n - 1

= 15,999*0.0125*1.0125^36/1.0125^36 - 1

= 312.7692/0.5639

= $554.61

Thus size of each monthly payment = $554.61

Loan amortization schedule:

Month Loan amount at start of month Payment Interest Principal Loan amount at end of month
1 15999      554.61 199.99      354.62            15,644.38
2                    15,644.38      554.61 195.55      359.06            15,285.32
3                    15,285.32      554.61 191.07      363.54            14,921.78
4                    14,921.78      554.61 186.52      368.09            14,553.69
5                    14,553.69      554.61 181.92      372.69            14,181.00
6                    14,181.00      554.61 177.26      377.35            13,803.65
7                    13,803.65      554.61 172.55      382.06            13,421.59
8                    13,421.59      554.61 167.77      386.84            13,034.75
9                    13,034.75      554.61 162.93      391.68            12,643.07
10                    12,643.07      554.61 158.04      396.57            12,246.50
11                    12,246.50      554.61 153.08      401.53            11,844.97
12                    11,844.97      554.61 148.06      406.55            11,438.42
13                    11,438.42      554.61 142.98      411.63            11,026.79
14                    11,026.79      554.61 137.83      416.78            10,610.01
15                    10,610.01      554.61 132.63      421.99            10,188.03
16                    10,188.03      554.61 127.35      427.26              9,760.77
17                      9,760.77      554.61 122.01      432.60              9,328.17
18                      9,328.17      554.61 116.60      438.01              8,890.16
19                      8,890.16      554.61 111.13      443.48              8,446.67
20                      8,446.67      554.61 105.58      449.03              7,997.65
21                      7,997.65      554.61 99.97      454.64              7,543.01
22                      7,543.01      554.61 94.29      460.32              7,082.68
23                      7,082.68      554.61 88.53      466.08              6,616.61
24                      6,616.61      554.61 82.71      471.90              6,144.70
25                      6,144.70      554.61 76.81      477.80              5,666.90
26                      5,666.90      554.61 70.84      483.77              5,183.13
27                      5,183.13      554.61 64.79      489.82              4,693.31
28                      4,693.31      554.61 58.67      495.94              4,197.36
29                      4,197.36      554.61 52.47      502.14              3,695.22
30                      3,695.22      554.61 46.19      508.42              3,186.80
31                      3,186.80      554.61 39.83      514.78              2,672.02
32                      2,672.02      554.61 33.40      521.21              2,150.81
33                      2,150.81      554.61 26.89      527.73              1,623.09
34                      1,623.09      554.61 20.29      534.32              1,088.76
35                      1,088.76      554.61 13.61      541.00                  547.76
36                          547.76      554.61 6.85      547.76 0

Related Solutions

A newly divorced father of two, looking to improve his image wants to purchase a Mercedes-Benz...
A newly divorced father of two, looking to improve his image wants to purchase a Mercedes-Benz in order to impress his young and foxy girlfriend. The car costs $17,999 and the car yard is willing to offer financing. The terms of the deal include a $2000 deposit (which the client has) with the remainder of the balance being repaid in equal monthly installments over the next three years. The car dealer charges 1.25 percent interest rate per month on the...
Your father gets a good job and wants to deposit in his account $1200 at the...
Your father gets a good job and wants to deposit in his account $1200 at the end of each year for 3 years. He earns 2% interest paid annually. How much will be in his account after 3 years? *
a) Adam wants to purchase a car and finance his purchase with a 3 year loan...
a) Adam wants to purchase a car and finance his purchase with a 3 year loan at 5% interest. If he wants his payments to be $475 per month, how much can he finance with this loan? b) Bernard purchased a car and financed his purchase with a loan at 5% interest. His payments are $475 per month. If he has 3 years left on his loan, what is his remaining balance? c) Carlton purchased a car and took out...
A decision-maker is a father who has two sons.They are going to purchase a new house....
A decision-maker is a father who has two sons.They are going to purchase a new house. Suppose there are five possible choices ω1, ω2, ... , ω5. The rankings of houses from the most favorite to the least favorite are as following: • Father: ω2, ω5, ω3, ω4, ω1; • Son 1: ω5, ω4, ω1, ω3, ω2; • Son 2: ω1, ω2, ω3, ω5, ω4. Suppose the decision-maker cares and only cares the feeling of his sons, and thus he...
Adam is a software developer and single father of two teenage sons. He and his sons...
Adam is a software developer and single father of two teenage sons. He and his sons love to barbeque every weekend and often have cookoffs to determine who can grill the best steak. Though Adam has always known he is carrying a little too much weight, he’s never really had any health concerns.  Within the last 6 months however, Adam has developed symptoms of fatigue, trouble breathing, and swollen ankles and feet. Today, his teenage son drove him to the emergency...
John received two properties from his deceased father (David) under a will. One property is a...
John received two properties from his deceased father (David) under a will. One property is a holiday house in Brisance and another is an investment property in Sydney. David has purchased the investment property in 1979 for $2.5m and he purchased the Brisbane property in 1990 for $2m. on the day that Davis passed ways each property had a market value of $5m. John wants to sell both properties. With reference to relevant legislation/case law discuss the CGT consequences of...
Problem 4 A father brings his two children to a pet store to buy them comet...
Problem 4 A father brings his two children to a pet store to buy them comet goldfish. When they arrive, they find that the store has a tank filled with exactly 1,024 individual comets. The father reasons that he should buy each child four comets in order to improve the odds of each child getting at least one long-living pet, as comet goldfish are cheap feeder fish that are being kept in poor conditions at the store. Determine the following:...
Junior just received his annual bonus and is looking to invest it in one of two...
Junior just received his annual bonus and is looking to invest it in one of two potential investments. Junior is considering a 10-year 9% coupon bond issued by HomeCo that is currently selling for $1,024.51. His other option is to buy stock in Residential Inc. Residential just issued a $1.2 dividend and expects to grow at 4%. Residential’s current stock price is $42.30. If both investments are fairly priced and Junior intends to hold the investment indefinitely, which offers a...
A father racing his son has half the kinetic energy of the son, who has two-fifths...
A father racing his son has half the kinetic energy of the son, who has two-fifths the mass of the father. The father speeds up by 3.0 m/s and then has the same kinetic energy as the son. (a) What is the original speed of the father? m/s (b) What is the original speed of the son? m/s
39) You are looking to purchase a property for 400,000. You have received two quotes. The...
39) You are looking to purchase a property for 400,000. You have received two quotes. The first quote is an 90% ltv 360-month amortization with a rate of 6%. The second offer comes from two sources. The first mortgage is 65% at 4.5% with 360-month amortization and the second mortgage takes the leverage to 90% at a rate of 12% with 360-month amortization. Which deal would you take?                                                 ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT