Layout References Insert Design Home Mailings Review View le Help Q4. Jade Kenyon is a free spirit who is saving her money to purchase a 36 foot, blue water capable, sailboat Assuming Jade wishes to have saved $50,000 at the end of five years and that her investment account will eam 5.50%, what bi-weekly deposit must she make to attain her savings target? Place the appropriate values in the proper cells in row 15, given the columns as provided below. The remaining instructions are stated in QI. Column letter D B Row Number 13 14 15 A Q4. E F Write problem type here. PMT FV #Yrs PV Ann Rate EXACT EXCEL FUNCTION: The following information is collected from http://reports.finance.yahoo.com as of 15-Feb-2011. Use it to answer the next question. Assume that both bonds have a dollar face value of $1,000, but quotes are on the basis of 100. SYNOVUS FINL CORP Bond Center OVERVIEW Price Coupon (%) Maturity Date Yield to Mat (%) Current Yield (%) Fitch Ratings Coupon Payment Freq Callable GE CAPITAL INTERNOTES 102.62 4.750 15-May-2015 ? 4.629 AA Semi-Annual Yes ? 5.125 15-Jun-2017 6.490 5.511 B Semi-Annual No Q1. Chris and Jeanine Wisecarxer borrowed $200,000 to purchase their home in River Oaks near Ponchatoula If their home was financed at a fixed annual rate of 5.375% using a 15-year mortgage, what is the amount of their monthly payment? Place the appropriate values in the proper cells in row 3, given the columns as provided below. Circle your answer in the relevant cell. Provide the EXACT Excel function that solves the problem using cell references throughout, in the space below. Note, where relevant, present value answers should be shown as a negative number