Calculate the first ten years of the income statement

Assignment Help Finance Basics
Reference no: EM13852456

Apartment Complex:

40 1-Bedroom Units Renting @ $700/month

25 2-Bedroom Units Renting @ $900/month

153-Bedroom Units Renting @ $1000/month

Other Income is 2% of the Potential Gross Rent

Vacancy Expense is 8% of Potential Gross Income

Loss Allowance is 2% of Potential Gross Income

Operating Expenses:

Property Taxes



75 Mills

Property Insurance



3% of EGI

Utilities:






Gas



10% of EGI


Electric



8% of EGI


Water & Sewer


5% of EGI


Telephone & Internet

0.5% of EGI


Trash



0.5% of EGI

Maintenance:





Supplies/Repairs


2% of EGI


Wages/Salaries


1% of EGI


Pest Control


1% of EGI


Carpet Cleaning/Power Washing

0.25% of EGI

Landscaping/Snow Removal


1.5% of EGI

Legal




1% of EGI

Turnover




30% of Avg Monthly Rent

Accounting



1% of EGI

Administration



0.5% of EGI

Management



5% of EGI

Your Qualified Loan: 70% LTV, 6.5% Interest Rate, 20 years, 10 year balloon, DCR = 1.4

Calculate the first ten years of the income statement through the ATCF.

Reference no: EM13852456

Questions Cloud

Draft fan-upgraded industrial process : A large induced-draft fan is needed for an upgraded industrial process. The motor to drive this fan is rated at 100 horsepower, and the motor will operate at full load for 8,760 hours per year. The motor’s efficiency is 92%. what is the present worth..
Analysis of the change in owners equity during the year : From an analysis of the change in owner's equity during the year, compute the net income and assuming Iverson made an additional investment of $46,181 and had no drawings in 2014
Is the plan devised by spencer and the cfo ethical : Is the plan devised by spencer and the CFO ethical? In answering this question, assume that Spencer and the controller are both firmly convinced that the new equipment will increase shareholder value.
Calculate franchises payback period and net present value : Calculate each franchise's payback period, net present value (NPV), internal rate of return (IRR), and modified internal rate of return (MIRR).
Calculate the first ten years of the income statement : Your Qualified Loan: 70% LTV, 6.5% Interest Rate, 20 years, 10 year balloon, DCR = 1.4. Calculate the first ten years of the income statement through the ATCF.
What income tax payments did 2014 liquidation cost supervalu : What additional income tax payments did the 2014 liquidation cost SUPERVALU? Assume an income tax of 40%.
Compute the expected new net income : Given the increased incentive, they expect net sales to increase by 15%. As a result, they estimate that gross profit will increase by $52,576 and expenses by $76,180. Compute the expected new net income. Then, compute the revised profit margin an..
Compute the equity method balance in patricks investment : Formulate your solution so that Shawns gross profit rate on sales to Patrick is treated as a variable - Create an Excel spreadsheet.
Alculate amount of current assets and current liabilities : Calculate the amount of current assets and current liabilities from the following: a) Current Ratio: 2.5:1, Working capital: ?60,000 b) Gross Profit : ?1,00,000, Total sales: ?5,25,000, Sales returns: ?25,000.Calculate Gross profit ratio.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd