need help

The following FV function was entered into an Excel worksheet to calculate the value of an investment: =FV(B3,B4,B5,B5,0) The following data was entered into an Excel worksheet: Rate of Return, cell B3, 5.5\% Investment duration in years, cell B4,15 years Amount invested at the beginning of each year, cell B5, $3,200 Given this information, which of the following are flaws in the FV function that was entered into the worksheet? Select all that apply. A minus sign must precede the cell location used to define the pmt argument. The percent symbol \% must follow the cell location used to define the rate argument. The [type] argument should be 1. The pmt argument should be zero. A minus sign must precede the cell location that is used to define the nper argument. The [pv] argument should be zero. The following PMT function was entered into an Excel worksheet: =PMT(B2/12,B3,B4,B5,1) The purpose of this function is to calculate the monthly payments for a loan. Payments are required at the end of each month. Which of the following identifies a flaw with this function. Select all that apply. A formula was used in defining the rate argument. The nper argument must be multiplied by 12 . The pv argument should also be divided by 12 . The [fv] argument should be zero. The nper argument must be divided by 12 . The [type] argument should be zero. The minus sign should precede cell B4 in the pv argument. The Excel worksheet below contains data for an annuity investment. In the space provided, enter the FV function to calculate the value of this investment at the end of 30 years. Assume the investment is made at the beginning of the first year and recurring investments are made at the beginning of every month. Type the function as if you were entering it into cell B5 on the Excel worksheet. Assume the loan payments are made at the end of each period. Which of the following PMT functions should be used to calculate the annual payments for this loan? =PMT(B7,B6,B5)=PMT(B6,B7,B5,00)=PMT(B6,B7,B5,0,1)=PMT(B6,B7,B5)