Question
In: Accounting
Given the following information regarding an income producing property, determine the net present value using unlevered...
Given the following information regarding an income producing property, determine the net present value using unlevered cash flows at a discount rate of 10%. Expected Holding Period: 5 years; 1st year Expected NOI: $91,200; 2nd year Expected NOI: $93,873; 3rd year Expected NOI: $96,626; 4th year Expected NOI: $99,462; 5th year Expected NOI: $102,383; 6th Expected NOI: 105,634; Debt Service in each of the next five years: $60,544; Current Market Value: $897,000; Required equity investment: $223,350; Apply a going-out capitalization rate of 8.75% to determine the Gross Sales Price at end of year 5 has Closing Expenses of $12,000 and Disposition Fee (Brokerage Commission) of 3% of Gross Sales Price.; Remaining Mortgage Balance at end of year 5: $631,126. Show your steps used in Excel.
Solutions
Expert Solution
| Calculation of Net Present Value | ||||||
| Year | 1 | 2 | 3 | 4 | 5 | |
| Expected NOI | $91,200 | $93,873 | $96,626 | $99,462 | $1,02,383 | |
| Debt Service | -$60,544 | -$60,544 | -$60,544 | -$60,544 | -$60,544 | |
| $30,656 | $33,329 | $36,082 | $38,918 | $41,839 | ||
| Discounting @ 10% | 0.9091 | 0.8264 | 0.7513 | 0.6830 | 0.6209 | |
| Present Value | = | $27,869 | $27,545 | $27,109 | $26,582 | $25,979 |
| = | $1,35,083 | |||||
| Gross Sale Price | = | Present Value/ Capitalization Rate | ||||
| = | 135083/8.75% | |||||
| = | $15,43,806 | |||||
| Value of Entity | = | $15,43,806 | ||||
| Less Closing Expenses | = | -$12,000 | ||||
| Brokerage | = | -$46,314 | ||||
| Net Value of Entity | $14,85,492 | |||||
| Less Value of Equity | $2,23,350 | |||||
| Value of debt | $12,62,142 | |||||
| Less Already Balance of Mortage | $6,31,226 | |||||
| Net | $6,30,916 |
ekkarill92 answered 2 years agoRelated Solutions
Given the following information regarding an income producing property, determine the NPV using levered cash flows...
Given the following information regarding an income producing
property, determine the NPV using levered cash flows in your
analysis: required equity investment: $270,000; expected NOI for
each of the next five years: $150,000; debt service for each of the
next five years: $125,000; expected holding period: five years;
required yield on levered cash flows: 15%; expected sale price at
end of year 5: $2,000,000; expected cost of sale: $125,000;
expected mortgage balance at time of sale: $1,500,000.
Develop a spreadsheet to determine the net present value or present worth of the following project:...
Develop a spreadsheet to determine the net present value or
present worth of the following project:
Bonus Depreciation: 0%
Investment: 140,000
Revenue/Savings: 25,000
Incremental Expense/Cost: 5,000
Salvage Value: 25,000
Project Life: 10 years
MACRS Schedule: 7 years
Tax Rate: 25%
MARR: 12%
Inflation: 3%
Is this a good investment to make?
Rework the problem with Bonus Depreciation of 50% and
100%
Determine the internal rate of return for the project in the
previous problem with all three levels of Bonus...
Given the following information, calculate the Net Present Value for a capital budget proposal? Show your...
Given the following information, calculate the Net Present Value
for a capital budget proposal? Show your work. Machine Cost:
$6,000,000 Salvage Value: $50,000 Setup Costs: $45,000 Training
Costs: $25,000 Annual maintenance costs: $45,000 Anticipated annual
savings: $560,000 Annual labor savings: $25,000 Expected useful
life in years: 12 Overhaul costs in year 4: $50,000 Annual
operating costs: $25,000 Hurdle rate: 8%
Net present value Using a cost of capital of 11%, calculate the net present value for...
Net present value Using a cost of capital of
11%, calculate the net present value for the project
shown in the following table and indicate whether it is
acceptable,
Initial investment
(CF
0CF0)
negative 1 comma 143 comma 000−1,143,000
Year
(t)
Cash inflows
(CF Subscript
tCFt)
1
$81,000
2
$138,000
3
$193,000
4
$258,000
5
$311,000
6
$377,000
7
$270,000
8
$98,000
9
$45,000
10
$29,000
The net present value (NPV) of the project is _____$ (Round
to the nearest...
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value...
Net present value. Independent projects Using a 14% cost of
capital, calculate the net present value for each of the
independent projects shown in the following table, and indicate
whether each is acceptable.
Project A
Project B
Project C
Project D
Project E
Initial investment
$26,000
$500,000
$170,000
$950,000
$80,000
Year
Cash inflows
1
$4,000
$100,000
$20,000
$230,000
$ 0
2
4,000
120,000
19,000
230,000
0
3
4,000
140,000
18,000
230,000
0
4
4,000
160,000
17,000
230,000
20,000
5
4,000...
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value...
Net present value. Independent projects Using a 14% cost of
capital, calculate the net present value for each of the
independent projects shown in the following table, and indicate
whether each is acceptable.
Project A
Project B
Project C
Project D
Project E
Initial investment
$26,000
$500,000
$170,000
$950,000
$80,000
Year
Cash inflows
1
$4,000
$100,000
$20,000
$230,000
$ 0
2
4,000
120,000
19,000
230,000
0
3
4,000
140,000
18,000
230,000
0
4
4,000
160,000
17,000
230,000
20,000
5
4,000...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and
the Net Present Value for the following after-tax cash flow
projections. Also tell me whether the IRR is greater or less then
the RRR.
A. Year ATCF
0 $(60,000)
1 21,000
2 27,000
3 24,000
4 16,000
Assume a 16% required rate of return
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and
the Net Present Value for the following after-tax cash flow
projections. Also tell me whether the IRR is greater or less then
the RRR
B. Year ATCF
0 (100,000)
1 (320,000)
2 130,000
3 185,000
4 200,000
5 195,000
6 150,000
Assume a 20% required rate of return
Given the following cash flows and a discount rate of 9.5%, the net present value is...
Given the following cash flows and a discount rate of 9.5%, the
net present value is closest to:
CF0 $ (27.50)
CF1 $ 8.75
CF2 $ 11.30
CF3 $ 14.90
St. Lawrence Ventures had cash flow from assets in 2014 of
$1,875 (all values in thousands). The company paid interest expense
of $370 and the cash flow to shareholders was $1,425. St.
Lawrence:
ct an answer and submit. For keyboard navigation, use the
up/down arrow keys to select an answer....
Using a Calculator and Present Value Table to Impute Interest Rate and Determine Present Value of...
Using a Calculator and Present Value Table to Impute
Interest Rate and Determine Present Value of Operating
Leases
AutoZone reports the following in its 2015 Form 10-K.
The Company leases some of its retail stores, distribution centers,
facilities, land and equipment, including vehicles. Other than
vehicle leases, most of the leases are operating leases...
The Company has a fleet of vehicles used for delivery to its
commercial customers and stores and travel for members of field
management. The majority of...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In each of the following situations, develop a tentative plan for the client. List the various...
- MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
- Java. If possible please put explanations for each line of code. Write a test program that...
- . Use the following information to calculate your company's expected return State Probability Return Boom 20%...
- You are considering the following two projects and can only take one. Your cost of capital...
- C++: Write a program that produces truth tables for the following compound propositions. Write the header...
- 1. What is the historical role of investment bankers ? Has this role changed ? Why...
ADVERTISEMENT