You want to buy a house in five years. You prefer to live in an area...

Question

Question

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 pric

business finance

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

WE HAVE TO FIND 'FV"

CELL REFERENCE IS PROVIDED OVL x ENG 08:20 12120 F L M N O P 1.25% RATE NPER PMT PV -325000 345826.70 [=FV(C3,C4,C5,C6,C8)] FV TYPE Sheet1 Sheet2 LOAN S

Add a comment

Answer 2

Similar Homework Help Questions

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....
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...
Please provide the formulas for excel as well Excel File Edit View Insert Format Tools Data...

Please provide the formulas for excel as well Excel File Edit View Insert Format Tools Data Window Hel ACFI 385 Excel Project Winter 2019(1) (2).xlsx 1 00% ▼ |Search in Sheet Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Aignme Fill ▼ Verdana Wrap TextCeneral Good Conditional Check Cell Insert Delete Format Themes Aa 41 ; * O ( Analyze the following scenarios that will require you to compute either the present value, future value, and/or the a...

You want to buy a car that will cost $33, 100. You have $2,750 cash as...

You want to buy a car that will cost $33, 100. You have $2,750 cash as a down payment. You will finance the remainder of the cost through a loan that will require equal monthly payments of principal and 6.75% APR interest over five years. Compute the amount of the monthly loan payment that you will need to make. Rate 6.75% Nper PMT PV FV Type Prepare a loan amortization schedule using the format presented below. Use the amortization schedule...
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:
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

Problem 3: How many years will it take for an intial investment of $2000, earning 5.4%...

Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...
You want to buy a new house. Your options are a tradition house for $350,000 and...

You want to buy a new house. Your options are a tradition house for $350,000 and a 3D printed concrete house for $100,000. These houses are built over a plot that increases 5% every year. You want to keep this house for 20 years and make a bit of money at the end. Which house would be the better option if both homes lose 2% of its value, but also increase due to an inflation of 3.22% every year?
You want to buy a car that will cost $33,100. You have $2,750 cash as a...

You want to buy a car that will cost $33,100. You have $2,750 cash as a down payment. You will finance the remainder of the cost through a loan that will require equal monthly payments of principal and 6.75% APR interest over five years Compute the amount of the monthly loan payment that you will need to make. Rate Nper PMT PV FV туре Prepare a loan amortization schedule using the format presented below. Use the amortization schedule to answer...

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

You want to buy a house in five years. You prefer to live in an area...

Homework Answers