Answer To: Mid-Term W16 Summer 2021 Mid-Term Student: • Use the provided answer sheet on the last page, any...
Akshay Kumar answered on Sep 01 2021
Answer Sheet
276 answer sheet, Final 2021
1 TRUE 16 D
2 TRUE 17 B
3 D 18 A
4 A 19 TRUE
5 TRUE 20 TRUE
6 FALSE 21 D
7 C 22 FALSE
8 A 23 FALSE
9 D 24 FALSE
10 B 25 C
11 A 26 $9,350,000.00
12 B 27 $9,060,800.00
13 C 28 $2,329,845.28
14 FALSE 29 35.63%
15 A 30 34.22%
Q 28,29,30
Rent Roll
Tenant Monthly Rent Year 1 Year 2 Year 3 Year 4
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Cam Reimbursements ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Less: Vacancy & Credit Loss ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Effective Gross Income ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Operating Expenses:
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Total ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Year 0 Year 1 Year 2 Year 3 Year 4
Net Operating Income $735,000
UBOC User: UBOC User:
Include TI and LC deductions $764,400 $794,976 $826,775
Principal ($82,989) ($87,235) ($91,698)
Interest ($420,633) ($416,387) ($411,924) Depreciation Schedule 39
Debt Service ($503,622) ($503,622) ($503,622) Terminal Cap Rate 6.50%
Target IRR 10.00%
Taxable Income Depreciation Recapture 28.80%
NOI $735,000 $764,400 $794,976 Capital Gains Tax 20.00%
Less: Interest ($420,633) ($416,387) ($411,924) Ordinary Income Tax 30.00%
Less: Depreciation ($166,667) ($166,667) ($166,667) Sales Expense 2.00%
Taxable Income $147,700 $181,346 $216,385
Income Tax ($44,310) ($54,404) ($64,916) Land Value $ 3,500,000
After Tax Cash Flow Building Value $ 6,500,000
Cash flow from operations Purchase Price $ 10,000,000
NOI $735,000 $764,400 $794,976
Less Debt Service $ (503,622) $ (503,622) $ (503,622) LTV 70%
Before Tax Cash Flow $231,378 $260,778 $291,354 Loan Amount $ 7,000,000
Income Tax ($44,310) ($54,404) ($64,916) Interest Rate on Loan 6.00%
After Tax Cash Flow $187,068 $206,374 $226,438 Amortization - Yrs 30
Annual Debt Service $ (503,622)
NPV
Initial Equity ($3,000,000)
ATCF $187,068 $206,374 $226,438 Total Principal (261,923)
Sale Price $12,719,616 Total Depreciation (500,000)
Sales Expense ($254,392)
Mortage Repayment ($5,363,077) Residual Value / Sale Price $ 12,719,616
Capital Gains Tax ($543,923) Basis / Purchase Price $ 10,000,000
Depreciation Recapture ($144,000) Capital Gain $ 2,719,616
Net Cash Flows ($3,000,000) $187,068 $206,374 $6,640,661
Rate 10.00%
NPV $2,329,845
IRR 34.22%
Roll Over Analysis
SQFT
Amo
UCD Amortization Schedule (Yellow cells = Input Cells)
$362,354.60
360 5.00% $30,196 $5,625,000 362354.595533194
TERM INTEREST INTEREST AND ORIGINAL
MONTHS RATE PRINCIPAL PAYMENT PRINCIPAL
TOTAL AVERAGE
INSTAL- INTEREST PRINCIPAL PRINCIPAL ANNUAL MONTHLY
MENT BALANCE PRINCIPAL PRINCIPAL
NUMBER PAYMENTS PAYMENTS
1 $23,438 $6,759 $5,618,241 $279,365
2 $23,409 $6,787 $5,611,454
3 $23,381 $6,815 $5,604,639
4 $23,353 $6,844 $5,597,796
5 $23,324 $6,872 $5,590,924
6 $23,296 $6,901 $5,584,023
7 $23,267 $6,929 $5,577,093
8 $23,238 $6,958 $5,570,135
9 $23,209 $6,987 $5,563,148
10 $23,180 $7,016 $5,556,131
11 $23,151 $7,046 $5,549,086
12 $23,121 $7,075 $5,542,011 82,989 6,916 261,923
13 $23,092 $7,105 $5,534,906
14 $23,062 $7,134 $5,527,772
15 $23,032 $7,164 $5,520,608
16 $23,003 $7,194 $5,513,415
17 $22,973 $7,224 $5,506,191
18 $22,942 $7,254 $5,498,937
19 $22,912 $7,284 $5,491,653
20 $22,882 $7,314 $5,484,339
21 $22,851 $7,345 $5,476,994
22 $22,821 $7,375 $5,469,619
23 $22,790 $7,406 $5,462,213
24 $22,759 $7,437 $5,454,776 87,235 7,270
25 $22,728 $7,468 $5,447,308
26 $22,697 $7,499 $5,439,808 ...