Your boss, a real estate business manager, has approached you for financial advice. She is interested in either purchasing or leasing a new car for her personal use. Aware of your financial expertise, she has asked you to develop a Spreadsheet Model that allows her to decide whether to buy or lease the vehicle. The retail price of the car she is interested in is $50,000. Buy Scenario In the Buy Scenario, your boss would like to purchase the car by making an initial down payment of $15,000 dollars and finance the difference with a conventional car loan to be repaid monthly for 3-years at a 5% interest rate. The following table summarises the relevant information for the Buy Scenario. Buy Scenario Car Price $ 50,000.00 Down Payment $ 15,000.00 Interest Rate 5% Term 3 years Lease Scenario In the Lease Scenario, there is no initial down payment. Instead, your boss would like to use a Finance Lease to rent the car for 3 years. At the end of this 3-year period, she plans to purchase the car from the lease financier (lessor) by paying a residual value of $25,000. In this scenario, to rent the car, your boss would have to pay a monthly rent of $850 for 3 years. The following table summarises the relevant information for the Lease Scenario. Lease Scenario Car Price $ 50,000.00 Residual Value $ 25,000.00 Monthly Rent $850 Term 3 years a. [5 marks] Lay out the decision-making problem, the alternatives, and the overall criteria you would use to evaluate the different alternatives. b. [5 marks] Carefully establish all the inputs and assumptions you would include in the Spreadsheet Model for each scenario. If you include inputs/variables other than the ones provided (e.g. interest rate on savings), justify your choices based on data from the Australian market. C. [10 marks] Based on your answers to a) and b), build a Spreadsheet Model which helps your boss decide whether to buy or lease the vehicle. Make your spreadsheet self- explanatory. d. (5 marks] Perform What-if analysis for at least one of your inputs (e.g. down payment). That is, show what would happen to your model's output at, at least, three different values of the chosen input. In your spreadsheet, highlight the section you would present to your boss to help her with her decision-making problem. e. (5 marks] Of all the inputs included in your model, which one do you think is the most important in determining whether buying or leasing is the best option for your boss? Provide an explanation. f. [5 marks] Describe the model's limitations and/or aspects that could be improved. What other factors haven't been considered? g. (5 marks] Are there any cognitive biases you would suggest your boss to be aware of when finally making her decision? Price Kms 1 N 3 3 4 5 6 7 8 9 10 69,700 66,900 61,900 61,000 59,000 49,000 54,800 42,800 46,900 45,000 43,000 45,900 35,500 34,600 34,900 31,900 36,500 28,000 27,000 19,000 13,400 21,100 15,900 62,000 43,000 80,000 41,200 152,000 130,000 120,000 94,000 111,900 135,000 167,000 142,300 220,000 122,000 206,500 226,000 275,000 11 12 13 14 15 16 17 18 19 20