Show your solution for the following problem using the Time Value of Money (TVM) Excel function in no more than two cells. The Bank Trust will pay $12,000 per year indefinitely with the first payment 13 years from today. If you earn an annual return of 2% in this account, find the value of these payments today. An example of a spreadsheet organization for Part II of the assignment is below. Clipboard G Fort Alignment 032 A B C D 1 Payment amount S 12,000 Enter as hardcoded First payment in # years 13 values 3 Return 2% 4 5 Value of payments today 6 7 Must be the TVM function and reference the data aboveSuppose you just borrowed $56,000 and arranged for a 2-year loan with monthly payments beginning one month from today. Prepare the amortization schedule for this loan. The interest rate is 4.50%. Show the total amounts in payment, interest, and principal. To complete this part efficiently, set up the formulas in the first row of the table, and utilize Copy/Paste to fill out the remaining cells. Below is an example of a spreadsheet organization for Part III of the assignment. B G Amount borrowed S 56,000 2 Term of the loan (yrs) 2 Enter as hardcoded 3 Frequency of payments 12 4.50% values Interest Monthly payment period Beginning PMT Interest Principal Ending balance balance 10 11 Must reference the data above or be a formula/function TotalsYour company produces candy and considers introducing a new avor. A year ago, the company spent $16,800 on a marketing survey to learn about consumer interest in this avor. If this new type of a candy is produced and offered for sale, the estimated revenue in Year 1 is $420,000. Sales are forecasted to grow at a rate of 3% per year. Incremental variable costs are expected to be 60% of incremental revenues. The net working capital in Year 0 is expected to be $75,000 with a full recovery at the end of the project. This project requires an immediate investment of $376,000 in equipment. The equipment is to be depreciated over 10 years on a straight-line basis to zero value. The new candy avor will be discontinued in 5 years, and the project will end. At the end of this project, the equipment will be sold for $164,000. The tax rate is 28%, and the required rate of return is 16%. Based on the NPV and IR investment criteria, should your company introduce a new candy avor? I) Should the cost of a marketing survey be included in your decision? Why or why not? (3 points) 2) Calculate the operating cash ow (OCF) for each year of the project. Show each item that goes into the OCF on its own row. (10 points) 3) Calculate the Initial Investment of the project. (3 points) 4) Calculate the Terminal cash ow of the project. (3 points) 5) Show lull recovery in the Investment in Net Working Capital. (3 points) 6) Calculate the Cash Flow from Assets for each year of the project. (3 points) 3") Calculate the project's NPV (NOTE: Make sure to use the NPV function in Excel correctly). (3 points) a. State whether you should introduce a new candy avor based on NPV. Explain Why. (2 points) 8) Calculate the project's IRR (use the Excel IRR function). (3 points) a. Based on IR, should you introduce a new candy avor? Explain Why. (2 points) An example of a spreadsheet organization for Part I of the assignment is below. The highlighted cells indicate the place for reporting the answers