Final answer:
The question involves financial analysis in Business using Microsoft Excel to calculate the present value at a 15% interest rate and analyze an individual's monthly expenses versus potential salaries.
Step-by-step explanation:
The subject of this question is Business, specifically focusing on financial analysis using Microsoft Excel. To calculate the present value of future amounts at a 15% interest rate, you would use the following formula in Excel: =PV(rate, nper, pmt, [fv], [type]), where 'rate' is the interest rate per period, 'nper' is the number of periods, 'pmt' is the payment made each period (if any), 'fv' is the future value, and 'type' is when payments are due.
After calculating the present value for each time period, you would sum these values to get the total present value. This exercise helps in understanding the time value of money, which is a fundamental concept in finance. To analyze Peter's financial situation, you would need to itemize and sum his monthly expenses, then compare the total to various potential salaries to see if he can meet his expenses. Finally, to give Peter advice on moving out, you would compare his income and expenses to determine if he is financially ready.