Question

How much will your house be worth if it appreciates at 7% a year, you bought it for 200,000 and you expect to sell it in 5 years? PV Pmt Fv Rate 5 You purchase a car for $25,000 and amortize it over a 5 year period. Your payment is $456 per month. Assume the car is fully amortized at the end of the 5 years. What is your annual rate of interest? PV FV PMT Rate Monthly Rate Annual Rate? You have been saving to start a business and realize you still have to pay the patent lawyers to file for a patent. You haveonly $50,000. A patent costs $75,000. How much longerdo you need to wait to filete patent ifyour money earns 14% compounded annually? PV FV PMT Rate

0 0
Add a comment Improve this question Transcribed image text
Answer #1

4)

Function Arguments 20000 PV 05,04.03) FV pmt 个= 0.07 Rate D6 Nper D5 Pmt D4 Rate 796 PV D3 个 = -200000 Type - number - 280510.3461 Returns the future value of an investment based on periodic, constant payments and a constant interest rate Type s a value representing the timing of payment: payment at the beginning of the period 1; payment at the end of the period 0 or omitted. Formula result S 280,510.35 elp on this functio OK Cancel

Hence, FV is $280,510.35

Add a comment
Know the answer?
Add Answer to:
How much will your house be worth if it appreciates at 7% a year, you bought...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 5 You purchase a car for $25,000 and amortize it over a 5 year period. Your...

    5 You purchase a car for $25,000 and amortize it over a 5 year period. Your payment is $456 per month. Assume the car is fully amortized at the end of the 5 years. What is your annual rate ofinterest? PV FV PMT Rate Monthly Rate Annual Rate?

  • aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...

    aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...

  • how much would you have to start saving per year if you wanted your 401(k)’s future...

    how much would you have to start saving per year if you wanted your 401(k)’s future value to be $1,500,000 by the time you want to retire? FV = 1,500,000 I = 8% PV = 50,000 N = 35 years PMT = ?

  • Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's...

    Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's degree program, when you turn 31 years old. At the end of each working year for 34 years, you put an additional $5,000 into an IRA a. Assuming you earn an annual compounded rate of 7.5 percent on the Rift and the IRA investments, how much would be available when you retire at age 65? b. If you hope to draw money out of...

  • please answer all 2pt per question. Show your work clearly to eam partial credit! Read the questions carefully!...

    please answer all 2pt per question. Show your work clearly to eam partial credit! Read the questions carefully! Suppose you invest $100, $200, & $300 at the end of year 1 to 3 in the next 3 years and earn 6% each year. What is the future value at the end of year 3? tcompute the PV: using CF function: CO0-0, CO1- 100, C02=200 , C03-300, I-6, CPT NPV= FV,=PV (1r)624.36 Suppose you expect your investment to earn 6 %...

  • Show your work as much as possible below each question to get full credit (Le, you...

    Show your work as much as possible below each question to get full credit (Le, you should provide information about PV: FV. PMT, I/Y, N ... before writing down your answer) 1. What is the present value of the following cash flow stream at a rate of 8.0%? Years: CFs: $2,450 $3,175 $4,400 2. You would like to travel in South America 5 years from now, and you can save $3,100 per year, beginning one year from today. You plan...

  • Suppose that you bought a house worth $400,000 by putting a down payment of $50.000 and by taking...

    Suppose that you bought a house worth $400,000 by putting a down payment of $50.000 and by taking out a loan for the rest at an interest rate of 42% compounded montly, payable with monthly payments for 30 years. Assume the payments are due at the end of each month. a. Find your monthly payments b. Suppose that 10 years later the house was worth $460,000. How much do you still owe on the house at that point. c. 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...

  • Suppose you take a 30-year mortgage of $300000. the annual interest rate is 4%, and the...

    Suppose you take a 30-year mortgage of $300000. the annual interest rate is 4%, and the annual ... Question: Suppose you take a 30-year mortgage of $300000. The annual interest rate is 4%, and the annual AP... (2 bookmarks) Suppose you take a 30-year mortgage of $300000. The annual interest rate is 4%, and the annual APR is 5.00%. Loan payments are made annually. Calculate the amortized fees and expenses for this loan (in dollars, provide your answer with $1...

  • Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan...

    Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT