Question

In: Finance

1. From the following building pro forma calculate the: All Risks yield (ARY)/ the Cash on...

1. From the following building pro forma calculate the: All Risks yield (ARY)/ the Cash on Cash Return / Capitalization Rate (Cap rate)

Purchase Price    

$     16,550,000

Loan Amount

$   13,240,000

Initial Equity

$     3,310,000

Potential Rental Income

$    2,184,000

Vacancy & Credit Loss

9.00%

Effective Rental Income

$    1,987,440

Other Income

$                -   

Gross Operating Income

$    1,987,440

Property Taxes

$       146,500

Insurance

$         15,000

Maintenance

$         90,000

Management Fee

$       262,080

Reserves for Replacement

$         35,000

Other expenses

$       122,000

Total Expenses

$       670,580

Net Operating Income

$    1,316,860

Debt Service

$       794,400

Cash Flow Before Tax

$       522,460

Solutions

Expert Solution

A) All risks yield (ARY)

All risks yield (ARY) = (Annual rental income / value of the property) * 1000

                                   = (1987440 / 16550000) * 100

                                   = 12 %

B) Cash on cash return

Cash on cash return = (annual before tax cash flow / total cash invested) *100

                                    = (522460 / 16550000) *100

                                    = 3.15 %

C) Capitalization rate

Capitalization rate = (net operating income / property cost) * 100

                                 = (1316860 / 16550000) * 100

                                  = 7.95 %


Related Solutions

Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in...
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in this case are budgeted statements for 2018 based on the new location scenario at the bottom of the page) Pro Forma Income Statement Pro Forma Balance Sheet PEYTON APPROVED PRO FORMA INFORMATION The company is planning to open another location in 2018 . Prepare pro forma financials for 2018 for the new location using the following information: 1. Cost of leasing commercial space: $1,500...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows...
prepare a 3-year pro forma income statement and pro forma balance sheet, including expected cash flows and all associated assumptions. Company: Bishrom (Nepali eyewear brand) outsources all the manufacturing in china. Please assume all the data. you can make a fake statement. Subject: Entrepreneurial finance
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Phoebe's Cat Foods​ Inc.: Total asset turnover   1.6 times Average collection period (assume 365-day year)   16 days Fixed asset turnover   6 times Inventory turnover (based on cost of goods sold)   2 times Current ratio   2.0 times Sales (all on credit)   $3,000,000 Cost of goods sold   75% of sales Debt ratio   60% Fill in the assets section of the pro forma balance sheet....
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 16 days Fixed asset turnover 6 times Inventory turnover​ (based on cost of goods​ sold) 2 times Current ratio 1.9 times Sales​ (all on​ credit) ​$5,000,000 Cost of goods sold 70​% of sales Debt ratio 40​% . Fill in the assets section of the pro forma balance...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s...
CASH BUDGET & PRO FORMA INCOME STATEMENT You are given the following information for the Thib’s Oil Service Company: Actual Sales 3rd QTR                    Estimated Sales 4th QTR July        $1,200,000                               Oct.                $3,000,000 Aug.       $1,400,000                              Nov. $5,000,000 Sept.     $1,600,000                              Dec.                $7,000,000 ****************************************************************** Actual Purchases 3rd QTR             Estimated Purchases 4th QTR July       $1,000,000                              Oct.                  $3,000,000 Aug.      $1,500,000                               Nov.    $4,000,000 Sept.     $2,000,000                               Dec.               $1,000,000 __________________________________________________________________ One-half (50 percent) of the sales each month are...
Suppose that you constructed a pro forma balance sheet and a cash budget for a company...
Suppose that you constructed a pro forma balance sheet and a cash budget for a company for the same time period and the external fi-nancing required from the pro forma forecast exceeded the cash deficit estimated on the cash budget. How would you interpret this result?
Describe the Pro Forma statement and the percent of sales method for future cash needs. What...
Describe the Pro Forma statement and the percent of sales method for future cash needs. What are the pros and cons of each method? Which method would you prefer to use and why?
1a. You have been asked to develop a pro forma statement of cash flow for an...
1a. You have been asked to develop a pro forma statement of cash flow for an office plaza. The information given to you is listed below: Property Information:                Age                                                                                        8 years                Rentable Space                                                                 300,000 sq.ft.                 # Stories                                                                              15                 # Tenants                                                                            40     Financial Information:                 Base Rent Avg.                                                                  $20 per sq.ft.                 Other Income/Parking                                                   $1.50 per sq.ft.                 Expenses Recoverable from Tenants                       $2.50 per sq.ft.                 Current Vacancy                                                               equals to 5% of...
2) What are the major differences between a “Pro Forma” Income Statement and a Cash Budget...
2) What are the major differences between a “Pro Forma” Income Statement and a Cash Budget (another name for this is Cumulative Cash Flow Statement). What would be the significance for each to a perspective lender?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT