Part C: EXCEL Questions. Develop your answers for each question on a separate tab and submit a single EXCEL file. Put your final answer for each question in the Answer Document and submit.

2. A line of credit loan of $100,000 is to be used to invest in a project. It is expected that the project will provide payments of $30,000 at the end of each year for 10 years, with the first payment at two years from now. When there is a balance owing in the account, interest is charged at = 10% per year, and when there is a surplus in the account, interest is credited at = 8% per year. Construct an EXCEL spreadsheet showing the account balance at the end of each year until the conclusion of the Project. [1 marks] (a) What is the Discounted Payback Period of this project? [1 mark] (b) What is the account balance at the beginning of year 11? [1 mark]

2. A line of credit loan of $100,000 is to be used to invest in a project. It is expected that the project will provide payments of $30,000 at the end of each year for 10 years, with the first payment at two years from now. When there is a balance owing in the account, interest is charged at ip = 10% per year, and when there is a surplus in the account, interest is credited at is = 8% per year. Construct an EXCEL spreadsheet showing the account balance at the end of each year until the conclusion of the Project. [1 marks) (a) What is the Discounted Payback Period of this project? [1 mark] (b) What is the account balance at the beginning of year 11? [1 mark]