Simone is now 50 years old and plan to retire at age 67 (in 17 years)....
Simone is now 50 years old and plan to retire at age 67 (in 17 years). She currently has a share portfolio worth $750,000, a superannuation fund worth $1,200,000, and a money market (similar to cash) account worth $500,000. Her share portfolio is expected to provide annual returns of 12% p.a. (compounded annually), her superannuation will earn her 9% p.a. (compounded annually), and the money market account earns 1.2% p.a. (compounded monthly). Assume all these returns are aftertax. Assume Simone’s superannuation contribution is $25,000 (after-tax) per year for the next 17 years (starting 1 year from now).
d. Simone is looking to purchase a Mercedes Benz SL500, which has a total cost of $350,000. To maintain sufficient liquidity, Simone plans to withdraw $150,000 from her money market account and will pay the rest by taking on a 6.6% p.a. (compounded monthly) 5-year bank loan. If Simone decides to repay $6,000 per month, how long will she pay off the car loan?
Need complete formula and calculation process.
Homework Answers
| Total cost | $3,50,000 |
| -Withdraw from money market account | -$1,50,000 |
| Loan Amount | $2,00,000 |
| No. of Payments | |
| 37 Months | |
| (From Repayment Schedule) |
| Month | Opening | Interest (Opening*6.6%/12) | Installment | Payment of Principal (Installment-Interest) | Closing (Opening-Payment of Principal) |
| 1 | $2,00,000 | $1,100 | $6,000 | $4,900 | $1,95,100 |
| 2 | $1,95,100 | $1,073.05 | $6,000 | $4,926.95 | $1,90,173.05 |
| 3 | $1,90,173 | $1,045.95 | $6,000 | $4,954.05 | $1,85,219.00 |
| 4 | $1,85,219 | $1,018.70 | $6,000 | $4,981.30 | $1,80,237.71 |
| 5 | $1,80,238 | $991.31 | $6,000 | $5,008.69 | $1,75,229.01 |
| 6 | $1,75,229 | $963.76 | $6,000 | $5,036.24 | $1,70,192.77 |
| 7 | $1,70,193 | $936.06 | $6,000 | $5,063.94 | $1,65,128.83 |
| 8 | $1,65,129 | $908.21 | $6,000 | $5,091.79 | $1,60,037.04 |
| 9 | $1,60,037 | $880.20 | $6,000 | $5,119.80 | $1,54,917.25 |
| 10 | $1,54,917 | $852.04 | $6,000 | $5,147.96 | $1,49,769.29 |
| 11 | $1,49,769 | $823.73 | $6,000 | $5,176.27 | $1,44,593.02 |
| 12 | $1,44,593 | $795.26 | $6,000 | $5,204.74 | $1,39,388.28 |
| 13 | $1,39,388 | $766.64 | $6,000 | $5,233.36 | $1,34,154.92 |
| 14 | $1,34,155 | $737.85 | $6,000 | $5,262.15 | $1,28,892.77 |
| 15 | $1,28,893 | $708.91 | $6,000 | $5,291.09 | $1,23,601.68 |
| 16 | $1,23,602 | $679.81 | $6,000 | $5,320.19 | $1,18,281.49 |
| 17 | $1,18,281 | $650.55 | $6,000 | $5,349.45 | $1,12,932.04 |
| 18 | $1,12,932 | $621.13 | $6,000 | $5,378.87 | $1,07,553.16 |
| 19 | $1,07,553 | $591.54 | $6,000 | $5,408.46 | $1,02,144.71 |
| 20 | $1,02,145 | $561.80 | $6,000 | $5,438.20 | $96,706.50 |
| 21 | $96,707 | $531.89 | $6,000 | $5,468.11 | $91,238.39 |
| 22 | $91,238 | $501.81 | $6,000 | $5,498.19 | $85,740.20 |
| 23 | $85,740 | $471.57 | $6,000 | $5,528.43 | $80,211.77 |
| 24 | $80,212 | $441.16 | $6,000 | $5,558.84 | $74,652.94 |
| 25 | $74,653 | $410.59 | $6,000 | $5,589.41 | $69,063.53 |
| 26 | $69,064 | $379.85 | $6,000 | $5,620.15 | $63,443.38 |
| 27 | $63,443 | $348.94 | $6,000 | $5,651.06 | $57,792.32 |
| 28 | $57,792 | $317.86 | $6,000 | $5,682.14 | $52,110.17 |
| 29 | $52,110 | $286.61 | $6,000 | $5,713.39 | $46,396.78 |
| 30 | $46,397 | $255.18 | $6,000 | $5,744.82 | $40,651.96 |
| 31 | $40,652 | $223.59 | $6,000 | $5,776.41 | $34,875.55 |
| 32 | $34,876 | $191.82 | $6,000 | $5,808.18 | $29,067.36 |
| 33 | $29,067 | $159.87 | $6,000 | $5,840.13 | $23,227.23 |
| 34 | $23,227 | $127.75 | $6,000 | $5,872.25 | $17,354.98 |
| 35 | $17,355 | $95.45 | $6,000 | $5,904.55 | $11,450.43 |
| 36 | $11,450 | $62.98 | $6,000 | $5,937.02 | $5,513.41 |
| 37 | $5,513 | $30.32 | $6,000 | $5,969.68 | -$456.26 |
Add Answer to:
Simone is now 50 years old and plan to retire at age 67 (in 17
years)....
Simone is now 50 years old and plan to retire at age 67 (in 17 years)....
Simone is now 50 years old and plan to retire at age 67 (in 17 years). She currently has a share portfolio worth $750,000, a superannuation fund worth $1,200,000, and a money market (similar to cash) account worth $500,000. Her share portfolio is expected to provide annual returns of 12% p.a. (compounded annually), her superannuation will earn her 9% p.a. (compounded annually), and the money market account earns 1.2% p.a. (compounded monthly). Assume all these returns are aftertax. Assume Simone’s...
Simone is now 50 years old and plan to retire at age 67 (in 17 years)....
Simone is now 50 years old and plan to retire at age 67 (in 17 years). She currently has a share portfolio worth $750,000, a superannuation fund worth $1,200,000, and a money market (similar to cash) account worth $500,000. Her share portfolio is expected to provide annual returns of 12% p.a. (compounded annually), her superannuation will earn her 9% p.a. (compounded annually), and the money market account earns 1.2% p.a. (compounded monthly). Assume all these returns are aftertax. Assume Simone’s...
Simone is considering to move funds from money market account to capital market. Her broker recommends...
Simone is considering to move funds from money market account to
capital market. Her broker recommends three investments.
Investment 1: Corporate Bond A
It has a face value of $100,000 with a 5.75% p.a. coupon rate.
Coupon is paid semi-annually. The bond will mature in five years.
Yield-to-maturity (YTM) is 6.5% p.a.
Investment 2: Preference Share B
It has a face value of $100 with a 10% p.a. preference dividend
rate. Cost of equity is 9% p.a.
Investment 3: Common...
Simone is considering to move funds from money market account to capital market. Her broker recommends...
Simone is considering to move funds from money market account to
capital market. Her broker recommends three investments.
Investment 1: Corporate Bond A
It has a face value of $100,000 with a 5.75% p.a. coupon rate.
Coupon is paid semi-annually. The bond will mature in five years.
Yield-to-maturity (YTM) is 6.5% p.a.
Investment 2: Preference Share B
It has a face value of $100 with a 10% p.a. preference dividend
rate. Cost of equity is 9% p.a.
Investment 3: Common...
Yumi's grandparents presented her with a gift of $22,000 when she was 9 years old to...
Yumi's grandparents presented her with a gift of $22,000 when she was 9 years old to be used for her college education. Over the next 8 years, until she turned 17, Yumi's parents had invested her money in a tax-free account that had yielded interest at the rate of 3.5%/year compounded monthly. Upon turning 17, Yumi now plans to withdraw her funds in equal annual installments over the next 4 years, starting at age 18. If the college fund is...
You wish to buy a house five years from now, which will expectantly cost $550,000 after...
You wish to buy a house five years from now, which will expectantly cost $550,000 after five years. You will pay parts of this price from your personal deposit. You will cover the rest of the purchase price by taking two types of loans at the time of purchase: a 4-year fixed-interest personal loan of $20,000 - a 25-year fixed-interest house loan for the rest of the house price (.e. after paying from the personal deposit and the $20,000 taken...
5) a) What is the present value of $40 earned 2-years from now if compounding was...
5) a) What is the present value of $40 earned 2-years from now if compounding was semi-annual and the interest rate is annually 3%? A "black box" just paid $20, which is expected to grow by 3% when the interest rate is 7% forever, what is the present value of this "black box" b) What is the future value of an annuity due with a $15 cash flow, 4% annual interest with quarterly compounding three-years from now? c) d) If...
1. You set up a college fund in which you pay $2500 each year at the...
1. You set up a college fund in which you pay $2500 each year at the end of the year. How much money will you have accumulated in the fund after 10 years, if your fund earns 13% compounded annually? Your Answer: 2. Lauren knows she can afford to make monthly payments of $300 for 36 months. How much will the bank lend her today on a 3% APR car loan in exchange for her promised monthly payments? Your Answer:...
1. a) A company estimates that it will need $53,000 in 17 years to replace a...
1. a) A company estimates that it will need $53,000 in 17 years to replace a computer. If it establishes a sinking fund by making fixed monthly payments into an account paying 4.8% compounded monthly, how much should each payment be? b) American General offers a 8-year annuity with a guaranteed rate of 6.05% compounded annually. How much should you pay for one of these annuities if you want to receive payments of $1400 annually over the 8 year period?...
An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age...
An individual is currently 30 years old and she is planning her financial needs upon retirement. She will retire at age 65 (exactly 35 years from now) and she plans on funding 20 years of retirement with her investments. Ignore any social security payments and ignore any taxes. She made $106,000 last year and she estimates she will need 75% of her current income in today's dollars to live on when she retires. She believes that inflation will average 3...
Simone is considering to move funds from money market account to
capital market. Her broker recommends three investments.
Investment 1: Corporate Bond A
It has a face value of $100,000 with a 5.75% p.a. coupon rate.
Coupon is paid semi-annually. The bond will mature in five years.
Yield-to-maturity (YTM) is 6.5% p.a.
Investment 2: Preference Share B
It has a face value of $100 with a 10% p.a. preference dividend
rate. Cost of equity is 9% p.a.
Investment 3: Common...
Simone is considering to move funds from money market account to
capital market. Her broker recommends three investments.
Investment 1: Corporate Bond A
It has a face value of $100,000 with a 5.75% p.a. coupon rate.
Coupon is paid semi-annually. The bond will mature in five years.
Yield-to-maturity (YTM) is 6.5% p.a.
Investment 2: Preference Share B
It has a face value of $100 with a 10% p.a. preference dividend
rate. Cost of equity is 9% p.a.
Investment 3: Common...
You wish to buy a house five years from now, which will expectantly cost $550,000 after five years. You will pay parts of this price from your personal deposit. You will cover the rest of the purchase price by taking two types of loans at the time of purchase: a 4-year fixed-interest personal loan of $20,000 - a 25-year fixed-interest house loan for the rest of the house price (.e. after paying from the personal deposit and the $20,000 taken...
5) a) What is the present value of $40 earned 2-years from now if compounding was semi-annual and the interest rate is annually 3%? A "black box" just paid $20, which is expected to grow by 3% when the interest rate is 7% forever, what is the present value of this "black box" b) What is the future value of an annuity due with a $15 cash flow, 4% annual interest with quarterly compounding three-years from now? c) d) If...
Most questions answered within 3 hours.
-
Write a program to solve the Josephus problem, with the following
modification:
Sample Input:
./a.out n...
asked 1 hour ago -
At the start of a CD it is spinning at a rate of 525 rpm
(revolutions...
asked 1 hour ago -
4. Without doing any calculations, predict whether the observed
∆T would increase, decrease or remain the...
asked 3 hours ago -
Based on the range, which of the following sets of scores has
the greatest variability? 3,...
asked 4 hours ago -
Ripples in a pond travel at a velocity of 3 m/s with one peak
passing a...
asked 4 hours ago -
A man stands on the roof of a building of height 13.0 mm and
throws a...
asked 4 hours ago -
The extent to which assets are financed by borrowed funds and
other liabilities is indicated by:...
asked 5 hours ago -
Explain in detail
Germany is the fifth largest economy
explain what goods and services Germany specializes...
asked 5 hours ago -
The density of platinum is 21.45 g/mL. If a cube of platinum
with a mass of...
asked 5 hours ago -
Accounts Receivable
Sales
A/R Posting
Extended Sales Invoice
Packing Slip
Compare invoice to packing slip 2...
asked 5 hours ago -
Michaella, age 23, is a full-time law student and is claimed by
her parents as a...
asked 5 hours ago -
Why are polymers not typically casted into products?
asked 5 hours ago