Fill out the Q blanks for each row, with excel. Please show formulas as well.

F. Given the following X-Corp.'s options between two CD offerings, perform the following tasks by applying appropriate techniques/ methods where necessary in M. Keep in mind that it is absolutely essential for you to figure out even the highlighted areas other than questions, though not directly asked, to correctly perform the task. The answer choices are found at the end of the problem group Which one is better? Maturity Citi Chase a. 139,995.19 10.25% 8.50% b. 49,158.52c.149,158.52 PrincinalAPR Comp in r) freuency SInterest FV (Maturity Value S/100,000.00 S100,000,00 015 016 d. 39,995.19 . 16 3. Logically and mathematically reason out the solution, and formulate computer-based models to solve the problems (Computer model Optional); warren borrowed S 14,000 on a noninterest-bearing, simple discount, 4.5% 60 day note. Assume ordinary interest. What are a i The maturity value, ii. Bank's discount, ili. Warren's proceeds, b Lionel deposits S7,00 n Victory bank, which pays 4% interest compounded semiannually. How much will Lionel c. Find the effective rate (APY) for the year given the principal-$8,000, interest rate 6% and compounded quarterly. d Bill needs $40,000 6 years from now to attend college. How much must Bill put in the bank every three months (8% e. Bob wants to buy his grandson a Ford Taurus in 4 years. The cost of the car is S28 000 Assuming a bank rate of4% f. Bernie wants to retire to California when she is 60 years of age. Bernie is 40 now. She believes that she will need iv. Effective interest rate to the nearest 100h have in his account at the end of 8 years? Round to the nearest 100 compounded quarterly) to reach his goal? compounded quarterly, how much must Bob put in the bank quarterly? 900,000 to retire comfortably To date, Bernie has set aside no retirement money. If Bernie gets 8% compounded semiannually, how much must she invest today to meet her $900,000 goal