You just started your internship at Burwood Value Asset Management. You were asked to write report for a couple by the name of David and Beth. David and Beth operate a small Italian restaurant on Burwood Highway. David is 45 and Beth is 42. They seek professional advice on their investments leading up to retirement. Your task is to write report for David and Beth addressing their inquiries. You are requested to submit two files for his review: ONE written report containing key summary tables (detailed below) and ONE Excel file containing all calculations with embedded Excel functions.

Section 1 - Required Savings for Retirement

The Association of Super Funds Australia (ASFA) suggests that to achieve a modest retirement lifestyle, a couple would need $46,620 a year (based on 2023 price) assuming that they own their home outright and are relatively healthy. The budget for a comfortable lifestyle amounts to $71,724 a year (based on 2023 price).1 The current plan is for the couple to retire at the same time when David turns 63 and Beth turns 60 and they expect to have 25 years in retirement. Recall that David is 45 and Beth is 42.

1.1 Assuming that the ASFA adjusts the retirement living cost according to an inflation rate of 2% per annum, how much do David and Beth need a year for them to achieve a modest retirement lifestyle when they retire? How much do they need a year for a comfortable lifestyle, according to the estimate from ASFA?

1.2 If David and Beth aspire to have very comfortable retirement that allows them some luxuries such as overseas travel and fine dining, they want to budget for $80,000 at the beginning of each year during retirement, how much money do they need upfront when they retire to achieve that lifestyle?

Note: Include the following tables in your report and explain to the clients how these figures are calculated. Calculate the amount required for retirement in Table 1.2 for three different scenarios with the discount rates ranging from 4% per annum to 6% per annum for the 25-year retirement period.