I. Problem Solving. Show necessary solutions For items 1-10, refer to the following: The owner of Dawn Winery decided to lend kegs of wine amounting to $ 50,000 to a certain bard who agreed to pay it within 7 years. (Hint: Compute for rate (j) of interest for each conversion period first) 1-2. How much will it cost (F) the bard if the wine has an interest of 5.5% and is compounded quarterly? 3-4. How much will it cost (F) the bard if the wine has an interest of 42% and is compounded semi- annually? 5-6. How much interest (I.) does the bard needed to pay if the wine has an interest rate of 4.7% and is compounded monthly? 7-8. Solve for the interest rate if it accumulated a total of $ 65,154.90 compounded quarterly 9-10. Solve for the interest rate if it accumulated a total of $ 76,145.10 compounded semi-annually.

4. PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASBancomer grants loans for the purchase of new automobiles, at 12½ % interest with monthly payments, for 4 years. It requests a minimum down payment of 10% and a maximum of 50% of the initial value of the car, excluding insurance and license plates. Considering the above, calculate the interest cost (effective rate) and the amount of the monthly payments considering the down payments from smallest to largest and varying from 10% to 10%. After a 30% down payment, the rate drops to 11.5%. The list cost of the car is $254,000.00. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.

You volunteer on a local fire department and are asked to help in the purchase of a new fire engine. You seek out a loan from a bank in which they state the annual interest on the loan would be 10%. However, the interest compounds once per quarter. What is the effective annual percentage rate (APR) if you select this loan?     10.38%     10%     15.1%     1.11%