MTH 154

Practice with Google Sheets/MS Excel

Finance

Complete the following tasks below. Some recommendations for clarity/organization:

1. Label your spreadsheet clearly. It’s very difficult to read and interpret long columns of

numbers if we don’t know what they mean. If you are looking at a column of numbers showing

the cu

ent balance or interest, label it as such.

2. Use tabs. A great way to organize these tasks is to do each problem on a new tab. You can

name the tabs Problem 1, Problem 2, etc. Then when you are ready to submit your work,

everything is on one sheet with multiple tabs.

3. Submit your work through Canvas when you are all done. If you are using Excel, save

your work and submit an .xlsx file. If you are using Sheets, use the “Share” option and provide

the link so I can view your document.

Here are the tasks:

Problem 1. Invest $1500 into an account earning 4% simple interest. What amount is in the

account after 5 years? Make a separate column showing the interest.

Problem 2. Repeat Problem 1 with compound interest (compounded annually).

Problem 3. Gracie deposits $425 into an account earning 3.2% interest compounded quarterly.

Show the quarterly balance for the first two years.

Problem 4. Make an initial deposit (any amount you wish) into an account earning 7% APR

compounded annually. How long before your initial deposit grows by 50%? Drag as far down so

you can see when this happens.

Problem 5. Your lovely grandmother leaves you $20,000 in her will. Experts tell you if you

deposit this money into an account paying 9% interest compounded annually, and leave it there

untouched for 45 years, you will retire nearly a millionaire. Is this true?

Problem 6. Suppose you make $125 monthly payments into an account earning 5% APR

compounded monthly. What is the balance after 24 months?

Problem 7. Play around with this one: What monthly deposit would you need to make in order

to have $170,000 ready for your child in 15 years? Suppose the fund offers an APR of 5%.

Note 1: Make up any monthly deposit at first (it will be inco

ect) but program all of your

formulas. Then just change the monthly deposit and see what happens.

Note 2: If you are showing the monthly balance across 15 years, you’ll need 180 rows in

your spreadsheet.

Problem 8. You pay $8,000 for a municipal bond. When it matures after 20 years, you receive

$12,500. This shows about a 56.3% total return on investment. First, figure out the annual return

and then use Excel/Sheets to show that this agrees with the total return (to within a few cents).

Problem 9. Show an amortization table for the following loan:

A student loan of $24,000 with a fixed APR of 8% for 15 years.

Your table should show the fixed monthly payment ($ XXXXXXXXXXas well as how much of it goes to

principal and interest each month. After 15 years (180 payments) the balance should be $0 (paid

off).

Answered Same DayMar 05, 2022

P2

Invest $1500 into an account earning 4% simple interest. What amount is in the account after 5 years? Make a separate column showing the interest.

P $ 1,500.00 C. Interest $ 324.98

rate 4%

Time 5

P1

Invest $1500 into an account earning 4% simple interest. What amount is in the account after 5 years? Make a separate column showing the interest.

P $ 1,500.00 Interest $ 300.00

rate 4%

Time 5

P3

Gracie deposits $425 into an account earning 3.2% interest compounded quarterly. Show the quarterly balance for the first two years.

Pricipal $ 425.00 interst Amount $ 1,302.31

Rate 3.20%

Compounding period 4

Year 2

P5

Your lovely grandmother leaves you $20,000 in her will. Experts tell you if you deposit this money into an account paying 9% interest compounded annually, and leave it there untouched for 45 years, you will retire nearly a millionaire. Is this true?

Principal $ 20,000.00 Amount $ 966,545.72 Its Not True

Rate 9%

Period 45

P6

Suppose you make $125 monthly payments into an account earning 5% APR compounded monthly. What is the balance after 24 months?

Amount $ 125.00 Amount ($3,148.24)

APR 5%

Time 2

P7

Play around with this one: What monthly deposit would you need to make in order to have $170,000 ready for your child in 15 years? Suppose the fund offers an APR of 5%.

Amount $ 7,878.2 ($170,000)

rate 5%

period 15

P8

You pay $8,000 for a municipal bond. When it matures after 20 years, you receive $12,500. This shows about a 56.3% total return on investment.

First, figure out the annual return and then use Excel/Sheets to show that this agrees with the total return (to within a few cents).

Principal 8000 Amount 12500

Rate 2.2563%

Period 20

Amount 12500

P4

Make an initial deposit (any amount you wish) into an account earning 7% APR compounded annually. How long before your initial deposit grows by 50%? Drag as far down so you can see when this happens.

Amount 1000 Amount 1500.7

Rate 7%

Period 6 % Increase 50%

P9

Show an amortization table for the following loan: A student loan of $24,000 with a fixed APR of 8% for 15 years.

Your table should show the fixed monthly payment ($229.36) as well as how much of it goes to principal and interest each month. After 15 years (180 payments) the balance should be $0 (paid off)

APR 0.08

Years 15

Payment per year 12

Amount 24000

payment...

Invest $1500 into an account earning 4% simple interest. What amount is in the account after 5 years? Make a separate column showing the interest.

P $ 1,500.00 C. Interest $ 324.98

rate 4%

Time 5

P1

Invest $1500 into an account earning 4% simple interest. What amount is in the account after 5 years? Make a separate column showing the interest.

P $ 1,500.00 Interest $ 300.00

rate 4%

Time 5

P3

Gracie deposits $425 into an account earning 3.2% interest compounded quarterly. Show the quarterly balance for the first two years.

Pricipal $ 425.00 interst Amount $ 1,302.31

Rate 3.20%

Compounding period 4

Year 2

P5

Your lovely grandmother leaves you $20,000 in her will. Experts tell you if you deposit this money into an account paying 9% interest compounded annually, and leave it there untouched for 45 years, you will retire nearly a millionaire. Is this true?

Principal $ 20,000.00 Amount $ 966,545.72 Its Not True

Rate 9%

Period 45

P6

Suppose you make $125 monthly payments into an account earning 5% APR compounded monthly. What is the balance after 24 months?

Amount $ 125.00 Amount ($3,148.24)

APR 5%

Time 2

P7

Play around with this one: What monthly deposit would you need to make in order to have $170,000 ready for your child in 15 years? Suppose the fund offers an APR of 5%.

Amount $ 7,878.2 ($170,000)

rate 5%

period 15

P8

You pay $8,000 for a municipal bond. When it matures after 20 years, you receive $12,500. This shows about a 56.3% total return on investment.

First, figure out the annual return and then use Excel/Sheets to show that this agrees with the total return (to within a few cents).

Principal 8000 Amount 12500

Rate 2.2563%

Period 20

Amount 12500

P4

Make an initial deposit (any amount you wish) into an account earning 7% APR compounded annually. How long before your initial deposit grows by 50%? Drag as far down so you can see when this happens.

Amount 1000 Amount 1500.7

Rate 7%

Period 6 % Increase 50%

P9

Show an amortization table for the following loan: A student loan of $24,000 with a fixed APR of 8% for 15 years.

Your table should show the fixed monthly payment ($229.36) as well as how much of it goes to principal and interest each month. After 15 years (180 payments) the balance should be $0 (paid off)

APR 0.08

Years 15

Payment per year 12

Amount 24000

payment...

SOLUTION.PDF## Answer To This Question Is Available To Download

- MATH XXXXXXXXXX/22) Computational Methods and Numerical Techniques Contribution: 25% of course Course Leader: Dr Kayvan Nejabati Zenouz Coursework 2 Deadline Date: Thursday 17/03/2022...SolvedMar 16, 2022
- Assessment 1: Review literatureHide Folder InformationInstructionsOverviewLength: 1500 wordsWeight: 30%Due date: End of Week 2 (11.59pm Sunday)This assessment requires you to build strategies for...SolvedMar 15, 2022
- COMP 3007 Final Take-home - Page 2 of 7 Due: TBD - See wallPart 1: The method of Gradient Descent2.1 GoalThe goal of this project is to find the zeroes of a certain class of function using...SolvedMar 11, 2022
- 21. Solve the following differential equation:y′′(x) + 6y′(x) + 25y(x) = 0.32. Consider a linear differential equationay′′ + by′ + cy = f(x)with constant coefficients. Let y1(x), y2(x) be...SolvedFeb 19, 2022
- Math 1104C, 1104J: Test # 1, Due Feb. 9 11:59, 2022Directives:• This document has 2 pages (including this page).• This assignment is due on February 9th at 11:59 on Brightspace.• The...SolvedFeb 09, 2022
- Grading SheetMajor Assignment 2 Grading SheetCompetencyRequirements for full credit(optional for student use) Did you meet the requirements?Points possibleYour pointsScoring...SolvedFeb 05, 2022
- MATH2004C Assignment 1Last Name: First Name:Student ID:• You may either write your answers on a copy of this assignment, or on your ownpaper or on your electronic devices (you do not need to...SolvedFeb 05, 2022
- WH 3SolvedFeb 04, 2022
- For Major Assignment 3 in Topic 6, you will develop a project to provide humanitarian assistance to people in your local community.For this DQ, you will look ahead at the project instructions and take...SolvedJan 30, 2022
- WH2SolvedJan 28, 2022

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.