file oome: praject a-last noml Objective: concepts of time value of money and solve the problems Requirement: Create a worksheet in Excel, and use the following syntax to answer 9 questions. Each student has to complete 9 questions. Your worksheet must show answers from typing in the syntax and argument Purpose Find the future value Find the present value Function fvlrate,nper.pmt, (pvl.type) pv(rate,nper,pmt./fvl.type) pmtfrate,nper,py,ltvl.type) Enpertrate.pmt,pv. vl.type) rate(nper,pmt,pv.ltv].type) Payment Number of periods Yield (Interest rate) n. Rate is the interest rate per period. For example, if the interest There are five arguments in each functio rate per period is 5%, you will type .05 for this argument. Nper is the total number of periods, pv is the t is the dollar amount of the periodic payment. The "type" argument tells Excel whether the cash flows occur at the end (0) or beginning (1) of the period. The bracket,"I1", means that you will input a negative value in order to return a positive value for the answer Example: Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? Answer: In a cell of the Excel spreadsheet, type -fv(.085,8,0,-125,0). Excel will return the answer $240.08