Discussion
Question 1 : 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]
Check the attached for additional questions.
NOTE: My budget for this job is $4. If you can’t meet the budget please don’t bid.
adminX
Subject expert at Treatisely.