MATH 144 Grand Canyon University Loan Payment Accounting Worksheet

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 n times 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 two year’s time?
2. How much will be interest?
3. Why wouldn’t a linear model work here?

Here is one option to research accounts that does not require personal information:

NerdWallet

A Microsoft Excel spreadsheet is required for this D

For this assignment, I will use country Kenya as the setting for the tour. Kenya is a country located in the East Africa. It is
one of the vibrant country with spectacular landscapes and variety of cultural sites.
Country
Kenya
Duration in Weeks
5
Participants
10
Population
47,564,296
Calculations
Number of Periods
Participants
Population
35
840
3024000
10
10
10
47,564,296
47,564,296
47,564,296
Per Day
Per Hour
Per Second
Running head: UNIT CONVERSION
The conversion reveals that the project is unreasonable. Kenya has a population of 47,564,296
(Githaiga,
2019). If I visit the country with ten participants for five weeks would mean that in one day, I
Source: https://www.worldometers.info/world-population/papua-new-guinea-population/
must interact with 135, 898 people. In every one hour, I and my team should meet and interact with 5,662
people. This translates to almost 2 persons per second.
untry located in the East Africa. It is
Persons per period
135,898
5,662
1.57
a population of 47,564,296
would mean that in one day, I
ld meet and interact with 5,662