Key Assumptions Construction cost ($) Loan ($) Loan interest rate Loan term (yrs.) Hangar space (sq.ft.) Rent ($/sq.ft. per month) Rent inflator Operating Costs ($/yr.) Cost inflator Tax rate Discount rate Depreciation/year ($) 1,250,000 400,000 Cash Flows Rent Income minus: Operating Costs minus: Interest minus: Depreciation = Taxable Income minus: Taxes 24,000 1.20 2.0% 144,000 6.0% 5 = - Total Cash Flows 2.0% 21.0% 7.0% 10,000 - Net Income minus: Principal = Net Operating Cash Flow minus: Cash Outlay at Start plus: Depreciation NPV IRR

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
1
2
3 Construction cost ($)
4 Loan ($)
A
5
Loan interest rate
6 Loan term (yrs.)
7 Hangar space (sq.ft.)
8 Rent ($/sq.ft. per month)
9 Rent inflator
16
17
18
19
Key Assumptions
10 Operating Costs ($/yr.)
11 Cost inflator
12 Tax rate
13 Discount rate
14 Depreciation/year ($)
15
20
21
1,250,000
400,000
B
Cash Flows
Rent Income
minus: Operating Costs
minus: Interest
minus: Depreciation
= Taxable Income
minus: Taxes
6.0%
5
24,000
1.20
2.0%
144,000
2.0%
21.0%
7.0%
10,000
= Net Income
minus: Principal
= Net Operating Cash Flow
minus: Cash Outlay at Start
plus: Depreciation
= Total Cash Flows
C
Start
D
Year 1
E
Year 2
F
Year 3
G
Year 4
H
Year 5
I
Year 6
J
Year 7
K
Year 8
22
23
24
25
26
27
28
NPV
IRR
29
30 Note: Tax shields are the tax gains from expensing interest and depreciation. The formula is interest or depreciation expense times the tax rate
31
L
Year 9
M
Year 10
N
TV
0
Transcribed Image Text:1 2 3 Construction cost ($) 4 Loan ($) A 5 Loan interest rate 6 Loan term (yrs.) 7 Hangar space (sq.ft.) 8 Rent ($/sq.ft. per month) 9 Rent inflator 16 17 18 19 Key Assumptions 10 Operating Costs ($/yr.) 11 Cost inflator 12 Tax rate 13 Discount rate 14 Depreciation/year ($) 15 20 21 1,250,000 400,000 B Cash Flows Rent Income minus: Operating Costs minus: Interest minus: Depreciation = Taxable Income minus: Taxes 6.0% 5 24,000 1.20 2.0% 144,000 2.0% 21.0% 7.0% 10,000 = Net Income minus: Principal = Net Operating Cash Flow minus: Cash Outlay at Start plus: Depreciation = Total Cash Flows C Start D Year 1 E Year 2 F Year 3 G Year 4 H Year 5 I Year 6 J Year 7 K Year 8 22 23 24 25 26 27 28 NPV IRR 29 30 Note: Tax shields are the tax gains from expensing interest and depreciation. The formula is interest or depreciation expense times the tax rate 31 L Year 9 M Year 10 N TV 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Risk Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education