60.1K

Verified Solution

Link Copied!

please help with the following questions on excel, thank you

2) A loan has a term of 6 months at 8.5% interest compounded monthly. If the payments are $153.74, what is the principal? 3) Kelly purchased a toaster for $105. She made a down payment of 15% and financed the rest for 6 months with payments of $21.50 per month. Find a) the down payment b) the total installment price of the toaster 4) A house sells for $379,000 and a 20% down payment is made. A 30 -year mortgage is secured at 5.25% interest compounded monthly. Find a) the amount of the down payment b) the amount of the mortgage (PV) c) the monthly payment d) the total interest paid 5) Dawn has $150,000 in her annuity account. How much can she withdraw every month for 25 years if the account earned 4.2% interest compounded monthly? 6) Ricardo is a 30-year old pack and a half per day smoker who pays $10.49 per pack of cigarettes. Observing his uncle suffering from emphysema, he decides to stop smoking. To help motivate and reward himself, he decided to put the cost of cigarettes into an annuity until he is 65 . Assuming an annuity with n interest rate of 5.1% compounded monthly and investing the cost of 45 packs each month. a) Find the future value of the annuity when Ricardo is 65 . b) Find the amount he can withdraw from his annuity each month for 20 years after he retires

Answer & Explanation Solved by verified expert

See Answer