Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please help with the following questions on excel, thank you image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Financial Machine Learning

Authors: Marcos Lopez De Prado

1st Edition

1119482089, 978-1119482086

More Books

Students also viewed these Finance questions