Question

1. You are thinking about buying the Ben Paradigm for $4.95 million. The owner needs to...

1. You are thinking about buying the Ben Paradigm for $4.95 million. The owner needs to sell soon so he says he’ll sell it to you for $4 million if you pay him $6 million in five years. What is the interest rate on this loan?

2. You are just starting graduate school part-time, and you’ve decided you want to buy a used Pete's watch when you graduate in four years. The watch will cost $34,995. You think you can save $600 a month during your four years of college. If interest rates are about 4%, will you be able to buy the watch when you graduate?

3. You are thinking about buying Siesta Key off the coast of Florida for $15.8 million. The owner says that if you give him a $2 million down payment, he will give you a 30-year, 5% loan. If you buy it, what will your monthly payment be?

4.  If you deposit $1,000 into an account that pays 3% interest, how much will you have in twenty years?

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

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

AS NOTHING WAS MENTIONED, USED EXCEL. IF YOU NEED WITH FORMULAS, WILL DO THAT ALSO. THANK YOU

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ B า 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 conditional Format . Cell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard DE59 DC Alignment Number Cells DE DF DG DH DI DJ DK DL 59 60 61 62 63 64 65 1 PV 4 FV YEARS RATE ON LOAN 6 8.45% EXCEL-RATE(5,,-4,6) 34,995.00 4 2 COST OF WATCH YEARS PMT RATE FUTURE VALUE NO, AS FUTURE VALUE IS LESS THAN COST OF WATCH 67 68 69 70 71 72 73 74 75 76 4% $31,175.76 EXCEL-FV(4%/12,4*12,-600) 3 LOAN 15.8-2- LOAN AMOUNT YEARS RATE PMT ( INSTALME 13.8 13800000 30 5% $ 74,081.38 EXCEL-PMT(5%/12,30*12-13800000) 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity i CAP STRU VALUE BOX DILUTION- DOLLAR COST AVG·MORTGAGE.. EXPO Sheet1 . Sheet2. Sh4( rences: x261 07-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy B า 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard DE95 DC Font Alignment Number Styles Cells Edting DE DF DG DH DI DJ DK DL 78 79 80 81 82 83 84 85 86 87 4 PV YEARS RATE FUTURE VALUE 1000 20 3% $ 1,806.11 EXCEL-FV(396,20,,-1000) 89 90 91 92 93 94 95 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity i CAP STRU VALUE BOX DILUTION- DOLLAR COST AVG·MORTGAGE.. EXPO Sheet1 . Sheet2. Sh4( rences: x261 02:24 07-01-2019

Add a comment
Know the answer?
Add Answer to:
1. You are thinking about buying the Ben Paradigm for $4.95 million. The owner needs to...
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
  • 1. You own the 1956 Bentley pictured to the right. The car cost you $45,000, but...

    1. You own the 1956 Bentley pictured to the right. The car cost you $45,000, but you need to sell it, and have it listed for $42,000. Your friend says he wants to buy it, but he can’t get a loan. He says that he can pay you $9,999 next year, $11,999 the following year, $9,999 in the year after that, and $11,999 in four years. If interest rates are about 2%, should you take the deal? Justify your answer....

  • You are thinking about buying a piece of art that costs $50,000. The art dealer is...

    You are thinking about buying a piece of art that costs $50,000. The art dealer is proposing a deal: She will lend you the money, and you will repay the loan by making the same payment every year for the next 10 years. If the interest rate is 4% compounded annually, how much will you have to pay every year ?

  • You are thinking about buying a rental property. Because of the difficulty getting a loan, you...

    You are thinking about buying a rental property. Because of the difficulty getting a loan, you are going to pay $350,000 in cash for the house today. You think you can rent out the property for the next 10 years, receiving $1,400 in cash each month after your expenses and taxes, starting a month from today. At the end of ten years, you believe you will be able to sell the property for $425,000. If your discount rate is 7.2%...

  • Samle thinking about buying a bond for investment purposes. The one he is looking at has...

    Samle thinking about buying a bond for investment purposes. The one he is looking at has a face value 4000 a coupon rate of 6.5%, pays interest annually, and has 8 years to maturity. Sam knows that he can det 9 on investments similar to this one elsewhere in the marketplace. Compute the following: Present Value of the Face Present Value of the Coupon Stream Total Value If this bond is showing in the WSJ at 92, what is being...

  • You own the 1956 Bentley pictured to the right. The car cost you $45,000, but you...

    You own the 1956 Bentley pictured to the right. The car cost you $45,000, but you need to sell it, and have it listed for $42,000. Your friend says he wants to buy it, but he can’t get a loan. He says that he can pay you $9,999 next year, $11,999 the following year, $9,999 in the year after that, and $11,999 in four years. If interest rates are about 2%, should you take the deal? Justify your answer.

  • Question 3. (10 marks) A family member is thinking about funding his granddaughter’s university education in...

    Question 3. (10 marks) A family member is thinking about funding his granddaughter’s university education in 8 years when she is expected to enrol at UWI, St. Augustine. He opens a special savings account, where he can receive a lump sum in 8 years. If he is desirous of receiving $60,000 in 8 years when his granddaughter is matriculating, how much would you advise him to deposit in the savings account monthly if annual interest rate is 6%? Show all...

  • You are thinking about a vintage car that costs $50,000.  The car dealer proposes the following deal:...

    You are thinking about a vintage car that costs $50,000.  The car dealer proposes the following deal: He will lend you the money, and you will repay the loan by making the same payment every three months for the next 20 years (i.e. 80 total payments).  If the interest rate is 6% APR with monthly compounding, how much will you have to pay every three months?

  • You are thinking about a piece of art that costs $50,000. The art dealer proposes the...

    You are thinking about a piece of art that costs $50,000. The art dealer proposes the following deal: He will lend you the money, and you will repay the loan by making the same payment every three months for the next 20 years (i.e. 80 total payments). If the interest rate is 6% APR with monthly compounding, how much will you have to pay every three months? $1,080.03 $1,027.99 No answer is within $10 of the correct answer $1,101.23 $1,133.42

  • .6.5 Suppose that you are thinking about buying a car and have narrowed down your choices...

    .6.5 Suppose that you are thinking about buying a car and have narrowed down your choices to two options. The new-car option: The new car costs $31,000 and can be financed with a three-year loan at 7.63%. The used-car option: A three-year old model of the same car costs $14,000 and can be financed with a four-year loan at 7.25%. What is the difference in monthly payments between financing the new car and financing the used car? Use PMT=- -nt...

  • 21 Caspian Sea Drinks is considering buying the J-Mix 2000. It will allow them to make...

    21 Caspian Sea Drinks is considering buying the J-Mix 2000. It will allow them to make and sell more product. The machine cost $1.34 million and create incremental cash flows of $670,775.00 each year for the next five years. The cost of capital is 11.07%. What is the net present value of the J-Mix 2000? Answer format: Currency: Round to: 2 decimal places. #2 Caspian Sea Drinks is considering buying the J-Mix 2000. It will allow them to make and...

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