Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do you calculate the highlighted portion of Interest Paid and Depreiciation? You own a 35,000 SF office building that is 80% rented at $20.00/SF,
How do you calculate the highlighted portion of Interest Paid and Depreiciation?
You own a 35,000 SF office building that is 80% rented at $20.00/SF, with expense pass through to you of $5.00/SF. You pay a manager 3% of rental income at the property. You bought the building at the beginning of this year for $4,000,000 at 75% LTV. You are a 10% partner. Bank terms included a 4% rate and a 20-year amortization. Assume your personal tax rate is 24%. Long term capital gains will always be 20%. You can depreciate your total purchase price. Calculate your tax cash flow and taxable cash flow for year 1. TAX 80%*35,000*$20 $5*35,000 3% income Income Expenses Management Fee Net Operating Income Year 1 Cash Flow Analysis CASH $ 560,000 Income $ 175,000 Expenses $ 16,800 Management Fee $ 368,200 Net Operating Income $ annnn 560,000 175,000 16,800 368,200 $ USE TVM for PMT, then x 12 Debt Service ($3MM loan, 4%, 20-year amort) $ 218,153 Interest Paid $ Depreciation (Price /39) $ N=12, CPT FV. Get interest 118,180 paid in year 1. 102,564 Before Tax Cash Flow $ 150,047 Taxable income $ 147,456 Taxes $ 35,389 Taxes (Income -24%) $ 35,389 After Tax Cash Flow $ 114,658 You use the tax scenario to determine the taxes you will pay on your income after debt serviceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started