Great Deal! Get Instant $25 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »

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

Solution

Mohd answered on Mar 06 2022
76 Votes
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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here