Question

In: Finance

Bought a warehouse $1,000,000. The price appreciates 3% compounded annually and at the end of 10...

  1. Bought a warehouse $1,000,000. The price appreciates 3% compounded annually and at the end of 10 years, you decide to sell. What is the value of the warehouse?
  2. You borrow 80% of the value at the time of purchase. The loan has a term of 10 years, with 25-year amortization. The interest rate is 8%. What is the balloon amount at the end of the term?
  3. The rent from the property is equal to the mortgage payment for the whole term of the loan. What is the return percentage annualized from this transaction?

Solutions

Expert Solution

1.
=1.03^10*1000000
=1343916.37934412

2.
=FV(8%/12,12*10,PMT(8%/12,12*25,-80%*1000000),-80%*1000000)
=646106.44984997

3.
=RATE(10,0,-20%*1000000,1343916.37934412-646106.44984997)
=13.31065%

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Unless stated otherwise, interest is compounded annually, and payments occur at the end of the period....
Unless stated otherwise, interest is compounded annually, and payments occur at the end of the period. Face value for bonds is $1000. Financial Statements and Forecasting (15) You have the following information for Houdini Homes for Year 0: Houdini Homes: Income Statement (M$) Y0 Y1 Sales 1400 Cost of Goods Sold 700 SG&A (Selling, General and Admin) Expenses 200 Depreciation Expense 86 Earnings Before Interest & Tax (EBIT) 414 Interest Expense 34 Earnings Before Tax 380 Taxes (25%) 95 Net...
Interest is compounded annually unless stated otherwise. Payments are at the end of the year unless...
Interest is compounded annually unless stated otherwise. Payments are at the end of the year unless stated otherwise. All bonds have a face value of $1000. Taxes are 0 unless specified otherwise. 2. A project has a beta of 1.3. The risk-free return is 2% and the return on the market is 12%. The project has an IRR of 14%. a) If the firm’s cost of capital is 10%, will they take the project using the cost of capital? b)...
Interest is compounded annually unless stated otherwise. Payments are at the end of the year unless...
Interest is compounded annually unless stated otherwise. Payments are at the end of the year unless stated otherwise. All bonds have a face value of $1000. Taxes are 0 unless specified otherwise. Use the following information to estimate the weights for the cost of capital equation for STANCO: From the balance sheet: Assets = 800M. Debt = 200M and Equity = 600M The firm has 20M shares outstanding that trade for $50 per share. The market value of the debt...
Unless stated otherwise, interest is compounded annually, and payments occur at the end of the period....
Unless stated otherwise, interest is compounded annually, and payments occur at the end of the period. Face value for bonds is $1000. 10. (15) Ghost Screams is considering a new product line. It requires a new machine that will cost $24,000,000. The machine will be fully depreciated to a zero-book value on a straight-line basis over 3 years. The project will generate $72,000,000 in revenues each year for 3 years. Variable costs are 75% of sales and fixed costs are...
Interest is compounded annually unless stated otherwise. Payments are at the end of the year unless...
Interest is compounded annually unless stated otherwise. Payments are at the end of the year unless stated otherwise. All bonds have a face value of $1000. 3. Lettuce Unite expects free cash flows of $10B next year, growing by 15% until year 2. After year 2, the growth rate falls to 4%. The cost of capital is 14%. They have $2B in cash and marketable securities and $25B in debt. There are 8B shares outstanding. Find the share price.
$9,800 is deposited for 10 years at 6% compounded annually, determine the FV?
$9,800 is deposited for 10 years at 6% compounded annually, determine the FV?
On January 1, 20X4, Dudas Accounting Corp. bought $1,000,000 of 4.5% bonds that pay interest semi-annually...
On January 1, 20X4, Dudas Accounting Corp. bought $1,000,000 of 4.5% bonds that pay interest semi-annually on June 30 and December 31. The market rate of interest on January 1, 20X4, was 4%. The company intends to hold on to the bonds up to their December 31, 20X8, maturity date to collect all of the contractual cash flows. The market value of the bonds on December 31, 20X4, was $1,023,000. Dudas reports its financial results in accordance with IFRS. At...
What is the future value of $6,000 invested for 5 years at 10% compounded annually?
What is the future value of $6,000 invested for 5 years at 10% compounded annually? A. 9,255 B. 8,902 C. 9,751 D. 9,663
Compute the future value of: An initial $2,000 compounded annually for 10 years at 8% An...
Compute the future value of: An initial $2,000 compounded annually for 10 years at 8% An initial $2,000 compounded annually for 10 years at 10% An annuity of $2,000 for 10 years at 8% An annuity of $2,000 for 10 years at 10%
Consider a bond paying a coupon rate of 10% per year, compounded annually. Assume that the...
Consider a bond paying a coupon rate of 10% per year, compounded annually. Assume that the market interest rate (YTM or return on investments of like risk) is 15% per year. In other words you want a 15% return on the bond.   The bond has three years until maturity. The par value is $1,000. Assume that you buy the bond today for $885.84. 20)   What is the interest payment that you will receive each year (yr 1, yr 2, and...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT