Today is 1 January 2018. Judy is 20 years old today and she is planning to purchase a real estate with the price of $800,000 on 1 July 2028. Judy believes that, at the time of purchasing the house, she should have saving to cover the 20% of the house price (i.e., $160,000) over the period from January 2018 to June 2028 and she can borrow the remaining 80% of the house price (i.e., $640,000) through a 30- year mortgage (it starts from 1 July 2028) from MQU Bank at an interest rate of j12 = 6% p.a.
To save the 20% of the house price (i.e., $160,000), Judy plans to deposit x% of her monthly after-tax salary into a fund at the end of each month from July 2020 to June 2028. (30 marks). • Judy assumes that she can successfully graduate from university and find a job on 1 July 2020. Judy estimates that her initial before-tax salary will be $60,000 p.a. payable monthly. All her salary will be paid at the end of each month.
• Judy forecasts that her salary will grow at the rate of y% p.a. The salary adjustment will only be conducted at the beginning of February in each year. For example, it is assumed that her salary is $60,000 p.a. payable monthly from July 2020 to January 2021, and then her salary is $60, 000(1 + y%) p.a. payable monthly from February 2021 to January 2022. Judy assumes the value of y is same as the Australian CPI rate for 2017. You need to use FactSet to find the Australian CPI rate for 2017.
• The deposit fund yield is estimated to be 5.5% p.a. payable monthly (i.e., j12 = 5.5%) from July 2020 to December 2022 and is estimated to be 6.5% p.a. payable monthly (j12 = 6.5%) from January 2023 to June 2028.
• Assume that all her salary income is taxable. Progressive marginal individual income tax rates are as shown in table 1. Based on the projected income and tax rate from table 1, we can calculate the income tax for a financial year1 . Then we can calculate the tax installment and after tax salary for each income salary payment (for simplicity, we assume that there is no medicare levy.). For example, if income growth rate is 2% p.a., Judy’s annual income is $60,500 ($5,000 per month from July 2020 to January 2021 and $5,100 per month from February 2021 to June 2021) for the 2020–2021 financial year. Her annual income tax is $3, 572 + ($60, 500 ? $37, 000) × 0.325 = $11, 209.5. For each income payment, her tax instalment is $11,209.5/12=$934.125 and her after-tax income per month is $4,065.875 from July 2020 to January 2021 and $4,165.875 from February 2021 to June 2021.
Table 1: Individual income tax rates
Taxable income Tax on this income
0–$18,200 Nil
$18,200–$37,000 19c for each $1 over $18,200
$37,000–$87,000 $3,572 plus 32.5c for each $1 over $37,000
$87,000–$180,000 $19,822 plus 37c for each $1 over $87,000
$180,000 and over $54,232 plus 45c for each $1 over $180,000
a. i. Find Judy’s before-tax income per month from July 2020 to June 2028.
ii. Based on the table 1, calculate the annual tax amount for each financial year from July 2020 to June 2028.
iii. Calculate Judy’s after-tax income per month from July 2020 to June 2028.
b. Use Goal Seek to find the value of x.
c. i. Calculate Judy’s monthly loan repayment amount. Assume that the repayment is paid at the beginning of each month.
ii. Calculate the accumulated deposit value, if x = 35%.
iii. Calculate Judy’s average annual tax rate for each financial year from July 2020 to June 2028 (to calculate it, divide the total annual tax payment by Judy’s annual salary income.). Use a bar/column chart to present your results.
CPI from FactSet is 1.6
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Today is 1 January 2018. Judy is 20 years old today and she is planning to...
Paul J. and Judy L. Vance are married and file a joint return. Paul is self- employed as a dentist, and Judy is a college professor. Paul and Judy have two children. The oldest is Vince who lives at home. Vince is a law student at the University of Cincinnati and worked part-time during the year, earning $1,500, which he spent for his own support. Paul and Judy provided $6,000 toward Vince’s support. Jennifer is the youngest and lived in...
Today is 1 July 2018. Matt is 30 years old today. Matt has a portfolio which consists of three Treasury bonds (henceforth referred to as bond A, bond B and bond C). There are 200 units of bond A, 300 units of bond B and 500 units of bond C. • Bond A is a Treasury bond which matures on 1 January 2027. One unit of bond A has a coupon rate of j2 = 2.95% p.a. and a face...
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). 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...
QUESTION: 1 (6 marks) In March 2019 AAR Ltd reported net profits after tax of $500,000 for the year 2018 andannounced that it will pay the annual dividend on 1 June 2019. AAR expects the net profits after tax for 2019 to be 20% higher and it will maintain its current dividend payout ratio of 60%. AAR will pay the annual dividend for 2019 in 1 June, 2020. Karina Adams owns 10% of the ordinary share capital of AAR Pty....
1. Wildhorse purchased a patent from Vania Co. for $1,310,000 on January 1, 2018. The patent is being amortized over its remaining legal life of 10 years, expiring on January 1, 2028. During 2020, Wildhorse determined that the economic benefits of the patent would not last longer than 6 years from the date of acquisition. What amount should be reported in the balance sheet for the patent, net of accumulated amortization, at December 31, 2020? The amount to be reported...
part 2 only Required 1. Prepare journal entries for the following dates: a. July 1, 2019 b. June 20, 2020 c. June 30, 2020 d. July 1, 2020 2. Calculate the balance in each partner's capital account immediately after the July 1, 2020, entry. Help Me SOLVE IT Problem 11-6B Partnership entries, profit allocation, withdrawal of a partner LO2, 3, 4 CHECK FIGURES: 1a. Cr. Harris: $56.000: 1b. Cr. Davis: $110.600:1c. Cr. Harris: $157,500 On November 1, 2020, Harris, Davis,...
1) On January 1, 2021, California Financial purchases a building for $900,000, signing a 5%, 20- year mortgage. Installment payments of $5,939.60 are due at the end of each month, with the first payment due on January 31, 2021 Required: 1. Record issuance of the mortgage installment note on January 1, 2021. 2. Record the first monthly mortgage payment on January 31, 2021. 3. Record the second monthly mortgage payment on February 28, 2021. 4. Total payments over the 20...
Today is 1 January 2019. Kim is looking for an investment that will give her $500,000 in 5 years’ time so that she will have a sufficient deposit to purchase a $2.5m house in Sydney. Currently she has saved about $380,000 to contribute to the deposit. She has started looking at Treasury bonds as she thinks they are a relatively low risk investment. However, she did not study finance at University so does not have a good understanding of Treasury...
Employee #1 Colin Forth, 40 years old Annual Salary $80,000 Married with a 10-year-old son Studied part-time at Humber College for 2 months, and paid tuition fees of $1,500. Spouse, Emma has $65,000 income Employee #2 Renata Hoover, 45 years old Annual Salary $70,000 Single Studied full-time at University of Toronto for 4 months, paid tuition fees of $4,500 Renata’s 75-year-old father lives with her. Her father qualifies for disability tax credit and has no income. Assume: Both employees have...