In chapter 1 of the text we looked at calculating a monthly payment

In Chapter 1 of the text we looked at calculating a monthly payment for a loan. A related formula is to calculate the amount accruing when regular payments are made into an interest bearing account – often called the Savings Plan formula.
(A is the accrued amount after t years of making regular payments, PMT, into an account at interest rate, r%, compounded ntimes each year.)
A(t) = PMT·((1 + r/N)N·t – 1)/(r/N)
= PMT*((1 + r/N)^(N*t) – 1)/(r/N)
The second version is essentially in the form used in Excel
Suppose you want to buy a car and have decided that you can save $100 a month. Using information from an internet source, determine the current interest rate on savings accounts and use the information to answer the following:
1. How much money will you have saved in a year’s time?
2. How much will be interest?
3. Why wouldn’t a linear model work here?
extra help: Please see the attached pdf for an example of the layout of this DQ.
Don’t forget to use Excel and the necessary formulas.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.

Contact Us on WhatsApp

× How can I help you?