All questions are answered in Microsoft Excel

Thank you.

Problem #2: You need to accumulate $137,000 CAD [to be entered into cell B1] in 14 years [to be entered into cell B2]. You can earn a rate of 8.74% per year [to be entered into cell B3] on your account. 1 Future Value 2 Years 3 Annual Rate 4 5 Annual Payment 6 (a) How much should you be depositing at the end of each year to accumulate $137,000 after 14 years [cell B5]? Use the PMT function. (b) What is the correct formula (using 16 characters or less) that should be placed in cell B5