Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show how to enter into EXCEL 1. You have decided to place $153 in equal deposits every month at the beginning of the month into

Show how to enter into EXCEL 1. You have decided to place $153 in equal deposits every month at the beginning of the month into a savings account earning 4.69 percent per year, compounded monthly for the next 15 years. The first deposit is made today. How much money will be in the account at the end of that time period? Round the answer to two decimal places 2. What is the present value of the following annuity? $4,765 every half year at the beginning of the period for the next 9 years, discounted back to the present at 10.98 percent per year, compounded semiannually. Round the answer to two decimal places 3. You plan to buy a house in 4 years. You want to save money for a down payment on the new house. You are able to place $403 every month at the end of the month into a savings account at an annual rate of 4.03 percent, compounded monthly. How much money will be in the account after you made the last payment? Round the answer to two decimal places. 4. You are going to save money for your sons education. You have decided to place $2,329 every half year at the end of the period into a saving account earning 14.66 percent per year, compounded semi-annually for the next 8 years. How much money will be in the account at the end of that time period? Round the answer to two decimal places. 5. A car dealership offers you no money down on a new car. You may pay for the car for 5 years by equal monthly end-of-the-month payments of $549 each, with the first payment to be made one month from today. If the discount annual rate is 16.41 percent compounded monthly, what is the present value of the car payments? Round the answer to two decimal places. 6. What is the present value of the following annuity? $3,151 every quarter year at the end of the quarter for the next 11 years, discounted back to the present at 4.98 percent per year, compounded quarterly? Round the answer to two decimal places.

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

Risk Sensitive Investment Management

Authors: Mark H A Davis, Sébastien Lleo

1st Edition

9814578037, 978-9814578035

More Books

Students also viewed these Finance questions