Ray Pierce wants to buy a house in six years. He invests $20,000 immediately in an...
Ray Pierce wants to buy a house in six years. He invests $20,000
immediately in an account that pays
7.25% APR. He will then deposit $8,500 at the end of each of the
next six years in the account. How
much money will he have saved to buy the house in six years?
N:
I/Y:
PV:
PMT:
FV:
Mode:
Excel Formula:
Answer:
Homework Answers
Y
DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASEAdd Answer to:
Ray Pierce wants to buy a house in six years. He invests $20,000
immediately in an...
You want to buy a house in five years. You prefer to live in an area...
You want to buy a house in five years. You prefer to live in an area in which houses are currently selling at an average price of $325,000. You know that the average price of the houses in the area will likely increase by 1.25% per year over the next five years. What will be the average price of a house in the area in five years? Nper PMT PV You know that 20% of the price of the house....
A young graduate looks to save money to buy a house 5.00 years from today. He...
A young graduate looks to save money to buy a house 5.00 years from today. He is somewhat conservative and will invest his money in a bond fund that pays 2.00% annually. The graduate invests $8,943.00 today. How much will his account be worth in 5.00 years? Answer Format: Currency: Round to: 2 decimal places.
Michael is planning to buy a house in six years and wants to have $45,000 for...
Michael is planning to buy a house in six years and wants to have $45,000 for a down payment. He can earn 4% on his savings and wants to set aside a constant amount each year for the next six years, beginning in one year. How much will Michael have to save each year? Round to the nearest whole number and no commas. Answer:
Kevin Allen has the opportunity to invest in a project that will provide semi-annual cash payments...
Kevin Allen has the opportunity to invest in a project that will provide semi-annual cash payments of $6,200 over ten years plus an additional $15,000 at the end of the tenth year. How much should he be willing to invest in the project assuming he wants to earn 9.6% (APR) compounded semi-annually? N: I/Y: PV: PMT: FV: Mode: Excel Formula: Answer:
Please make sure my answers are correct. 8. Ina Guarnaschelli wants to install a pool with...
Please
make sure my answers are correct.
8. Ina Guarnaschelli wants to install a pool with a changing cabana and an outdoor entertainment center at her home. A contractor estimated that the entire project would cost $85,000 to complete currently. Ina believes that she can save enough over five years so that she will only need to borrow 50% of the project's price. a. Ina expects the cost of the project to increase by 2.5% per year over the five...
Ingrid wants to buy a $20,000 car in 7 years. How much money must she deposit...
Ingrid wants to buy a $20,000 car in 7 years. How much money must she deposit at the end of each quarter in an account paying 5.1% compounded quarterly so that she will have enough to pay for her car?
Assume that you want to buy a new car in 5 years, and that the price...
Assume that you want to buy a new car in 5 years, and that the price of the car will be $30,000. (Assume all cash flows occur at the end of the period throughout all of the Excel problems throughout our entire course.) Use Excel time value of money functions to solve the problems outlined below (one or more of these: PV, FV, RATE, NPER, PMT) (This question doesn't require a text box with written answers, but you need to...
Unfortunately this is my second time uploading this because instructions were not read properly. I need...
Unfortunately this is my second time uploading this because
instructions were not read properly. I need full excel formulas for
each answer. for example: PV(.085,5000,8,1000.0) this is required
for each answer. There are 6 in this one multi part question. Thank
you...
We were unable to transcribe this imageExcel File Edit View Insert Format Tools Data Window Hel 0书20% Tue 11:31 PM a 385excel project.xlsx fou A 100% QSearch in Sheet A Home Layout Tables Charts SmartArt Formulas Data Review...
Suzanne invests $20,000 in an account that pays 7% annual compound interest for 3 years. She...
Suzanne invests $20,000 in an account that pays 7% annual compound interest for 3 years. She wants to know how much money she will have at the end of each year. Please draw a timeline and show how much money Suzanne will have accumulated at the end of each calendar year (Years 1-3)
Linda wants to buy a house in five years. Linda can save $23,000 a year starting...
Linda wants to buy a house in five years. Linda can save $23,000 a year starting today. If the money is invested into an account that earns 8.35% nominal interest, about how much will there be in the account to buy a house in five years? $128,601.30 $147,222.39 $135,876.69
You want to buy a house in five years. You prefer to live in an area in which houses are currently selling at an average price of $325,000. You know that the average price of the houses in the area will likely increase by 1.25% per year over the next five years. What will be the average price of a house in the area in five years? Nper PMT PV You know that 20% of the price of the house....
Michael is planning to buy a house in six years and wants to have $45,000 for a down payment. He can earn 4% on his savings and wants to set aside a constant amount each year for the next six years, beginning in one year. How much will Michael have to save each year? Round to the nearest whole number and no commas. Answer:
Please
make sure my answers are correct.
8. Ina Guarnaschelli wants to install a pool with a changing cabana and an outdoor entertainment center at her home. A contractor estimated that the entire project would cost $85,000 to complete currently. Ina believes that she can save enough over five years so that she will only need to borrow 50% of the project's price. a. Ina expects the cost of the project to increase by 2.5% per year over the five...
Assume that you want to buy a new car in 5 years, and that the price of the car will be $30,000. (Assume all cash flows occur at the end of the period throughout all of the Excel problems throughout our entire course.) Use Excel time value of money functions to solve the problems outlined below (one or more of these: PV, FV, RATE, NPER, PMT) (This question doesn't require a text box with written answers, but you need to...
Unfortunately this is my second time uploading this because
instructions were not read properly. I need full excel formulas for
each answer. for example: PV(.085,5000,8,1000.0) this is required
for each answer. There are 6 in this one multi part question. Thank
you...
We were unable to transcribe this imageExcel File Edit View Insert Format Tools Data Window Hel 0书20% Tue 11:31 PM a 385excel project.xlsx fou A 100% QSearch in Sheet A Home Layout Tables Charts SmartArt Formulas Data Review...
Most questions answered within 3 hours.
-
An imprest petty cash fund of $600 was established for minor
disbursements. At the end of...
asked 8 seconds from now -
Sharpe Cutter is a small company that produces specialty knives
for paper cutting machinery. The annual...
asked 4 minutes ago -
Calculating the Ka of a weak acid from
pH:
The pH of a 0.68M solution of...
asked 5 minutes ago -
1.What process is pushing back against gravity in the very
center (the core) of sun-like stars?...
asked 25 minutes ago -
This question is from the textbook "Python for ArcGIS" by Laura
Tateosian:
Write a script "triangles.py"...
asked 23 minutes ago -
Which of the following is an impediment that makes it
difficult for firms to achieve the...
asked 24 minutes ago -
Calculate the amount of heat needed to boil 123.g of octane
(C8H18), beginning from a temperature...
asked 33 minutes ago -
my
prof asked us to make a problem set then we find solve it
Chi-Square Test...
asked 40 minutes ago -
In recent years, 80% of those accused of Driving Under the
Influence (DUI) get convicted (includes...
asked 49 minutes ago -
Why does Max Weber distinguish between "power," "authority," and
different types of authority? What is he...
asked 49 minutes ago -
What would the solow growth model look like if there was a
production function which had...
asked 55 minutes ago -
A company project has an initial cost of $40,000, expected net
cash flows of $9,000 per...
asked 56 minutes ago