Scenario

Today is 25 July 20XX.

You are the accountant for Regina Hotel, a boutique luxury resort in Queensland, Australia. The owner of the business, Matteo Jans, wants to invest some money. They are unsure whether they should put the money in an investment account that pays 7.6% interest per annum for a five year term (reinvesting the interest) and have asked you to calculate the amount that they would get at the end of the investment.

They are investing their own money and the return(s) will be subject to income tax even though the money will not be withdrawn until the end of the investment period because it is paid annually. The amount to be initially invested is $625,000. The owner earns over $180,000 per year and is in the top tax bracket. This means they will pay tax at the maximum rate.

Using the provided information, calculate the amount that the investment will return at the end of each period and the tax and Medicare levy that will be paid (to the nearest dollar) arising from the investment.

Resident income tax rates to be used (not including Medicare) are shown. The Medicare levy is an additional 2%.

Taxable income	Tax on this income
0 - $18,200	Nil
$18,201 - $45,000	19c for each $1 over $18,200
$45,001 - $120,000	$5,092 plus 32.5c for each $1 over $45,000
$120,001 - $180,000	$29,467 plus 37c for each $1 over $120,000
$180,001 and over	$51,667 plus 45c for each $1 over $180,000

need help completing table

Follow the table format and calculate each year's values based on the provided formulas.

Year	Starting value	Interest value	Before tax amount	Less taxation on interest value	Less Medicare on interest value	Annual close
1	$625,000	$47,500	$672,500	$21,375	$950	$650,175
2	$650,175	$49,413.3	$699,588.3	$22,236	$988.3	$676,364
3	$676,364
4
5