Premium Essay

Pro Forma Analysis Cash Flow Forecasting

In: Business and Management

Submitted By ivyacoba23
Words 1486
Pages 6
Pro forma analysis cash flow forecasting
Apartment Investment Case Study Scenario
An investor is considering buying an apartment building with 140 units offered for sale at $16,500,000. The subject apartment building has the following unit mix:
Additionally, the following assumptions are also being made by the investor in order to construct a 5-year cash flow pro forma:
Vacancy and Credit Loss
In the current market, vacancy and credit losses are running at 9%. Due to the improving market conditions as well as the investor’s prior experience leasing and operating multifamily buildings, it’s expected that vacancy will steadily decline over the next 5 years to 5%.
Potential Rental Income
Potential rental income is based on the above unit mix. The 1-bedroom and studio rental rates are expected to increase at 1% annually. The 2-bedroom units are expected to increase at 2% annually.
After a preliminary discussion with a relationship manager at a local bank it’s determined that a loan can be extended based on the lesser of a 1.25x debt service coverage ratio or 80% loan to value. Additionally, assuming the underwriting process doesn’t reveal any red flags, it’s expected that the loan will be based on a 20 year amortization and a 6% interest rate.
Operating Expenses
The following table breaks out historical operating expenses for the property as well as projected increases over the holding period. Reserves for Replacement
In addition to the above operating expenses a reserve for replacement of $250 per unit will also be included in this analysis.
Sales Price and Cost of Sale
The projected sale price is estimated by applying a conservative 3% annual growth rate to the acquisition price of the property over the 5 year holding period. Additionally, a 6% cost of sale is factored into the net sales proceeds to account for selling costs.

Similar Documents

Premium Essay

Solution to Polaroid Cash Flow Statement Analysis

...Solution to Polaroid Cash Flow Statement Analysis: |Observations | |Cash from operations is positive in 98 and 99 and becomes Negative in ’00 – a clear sign of weakness for a mature | |business – not unusual for a young startup. | |Loss in 98 to a small profit and a larger profit in 00. | |Inventory increased in 00 using up operating cash and this may be a sign of weak sales resulting in unintentional | |building of inventory. | |Receivables decline which provides cash but may also be a sign of sales weakness or more aggressive collections to | |compensate for weak cash position. | |Investing activities are using cash. | |Asset replacement exceeds depreciation suggesting that they are replenishing fixed assets. | |Cash from operations is not sufficient to cover fixed asset purchases so they are being funded from other sources. | |Sale of other assets is providing funds to pay for some of the fixed asset......

Words: 287 - Pages: 2

Premium Essay

Analyzing Pro Forma Statements

...Analyzing Pro Forma Statements FIN/571 Kalena Armstrong-Henry November 4, 2013 Analyzing Pro Forma Statements General and financial managers can both benefit from forecasting financial statements. Proforma statements assist financial managers to plan accordingly, in terms of the company’s financial needs. How much financing is needed and when it is needed can be determined by acquiring an estimate of the company’s future balance sheet accounts and income statement. Hence, the purpose of the Proforma analysis is to forecast the company’s financial statements under a particular condition (Parrino et al., 2012). Subsequently, total assets must equate the sum of total liabilities and owner’s equity; otherwise the manager must consider corrective action (Parrino et al., 2012). The Proforma analysis has been proven to be instrumental for general managers in the planning of inventory and employment intensities; particularly problems solving issues. During the developing stages of the forecasting a manager is permitted to analyze the results; thus, identifying potential “hot spots” and handling the issues accordingly. Dealing with “hot spots” with ample time to spare during the forecasting stage is vital to any financial manager. When performing a Proforma Analysis the financial manager can handle forthcoming issues weeks or months in advance; thus, providing the manager ample time to avoid a potential real-time calamity. Subsequently, the manager will gain the ability......

Words: 1327 - Pages: 6

Premium Essay

Mt 482 Cash Flow Analysis

...1. Analysis of the statement of cash flows suggests that this strategy was implemented during year 8. Specifically, during that year the cash flows of Land’s End to build up its inventory to implement its new policy are very high---$104.545 million cash outflow to acquire additional inventory. 2. Depreciation expense represents the allocation of the cost of fixed assets over the useful life of the asset. Amortization expense represents the allocation of the cost of intangible assets over the useful life of the asset. In each of these cases, the investing cash outflow occurs when the asset is acquired and not when its cost is subsequently allocated to expense. a. Increases in receivables cause operation cash flows to be less than net income because revenues (reflecting receivables) are included in the net income, but the related cash may not yet be received. On the other hand, decreases in receivables cause operating cash flows to be greater than net income because cash is received for revenues recognized in prior periods. b. Decreases in inventory causes net income to be higher than operating cash flows because sales revenue is recognized when earned but the inventory sold can be paid for in earlier periods. Increases in inventory cause operating cash flows to be less than net income because cash was used to increase inventory levels. When these inventories are subsequently sold revenues will be earned and net income will be increased. However, this......

Words: 395 - Pages: 2

Premium Essay

Ch 2 Financial Statement and Cash Flow Analysis

...Chapter 2—Financial Statement and Cash Flow Analysis MULTIPLE CHOICE 1. Which of the following items can be found on an income statement? a. Accounts receivable b. Long-term debt c. Sales d. Inventory ANS: C DIF: E REF: 2.1 Financial Statements 2. If you only knew a company’s total assets and total debt, which item could you easily calculate? a. Sales b. Depreciation c. Total equity d. Inventory ANS: C DIF: E REF: 2.1 Financial Statements 3. How do we calculate a company’s operating cash flow? a. EBIT - taxes + depreciation b. EBIT - taxes - depreciation c. EBIT + taxes + depreciation d. EBIT - Sales ANS: A DIF: E REF: 2.2 Cash Flow Analysis 4. Holding all other things constant, which of the following represents a cash outflow? a. The company sells a machine. b. The company acquires inventory. c. The company receives a bank loan. d. The company increases accounts payable. ANS: B DIF: E REF: 2.2 Cash Flow Analysis 5. Which of the following is a liquidity ratio? a. Quick ratio b. P/E- ratio c. Inventory turnover d. Equity multiplier ANS: A DIF: E REF: 2.3 Analyzing Financial Performance Using Ratio Analysis NARRBEGIN: Bavarian Sausage, Inc. Bavarian Sausage, Inc. Bavarian Sausage, Inc. posted the following balance sheet and income statement. Balance Sheet Cash Accounts Receivable Inventories Net Plant and $ 50,000 125,000 225,000 Accounts Payable Notes Payable Long-term debt $185,000 125,000 115,000 Equipment 525,000 Total Assets $925,000 Common......

Words: 5588 - Pages: 23

Premium Essay

Cash Flow

...Jim DeMello Case 1- Signal Cable Company; Cash Flow Analysis Case 2- Bigger Isn't Always Better; Financial Ratio Analysis Case 3- Playing the Numbers Game!; DuPont Analysis Case 4-Growing Pains; Financial Forecasting Case 5- There’s More to Us Than Meets the Eye!; Financial Analysis and Forecasting Case 6- Lottery Winnings-Looks Can Be Deceptive; Time Value of Money Case 7- It’s Better Late Than Never!; Retirement Planning Case 8- Paying Off That Dream House; Loan Amortization Case 9- Wake Up and Smell the Coffee!; Time Value of Money Case 10- Corporate Bonds-They Are More Complex Than You Think; Bond Analysis and Valuation Case 11- How Low Can It Go?; Application of Stock Valuation Methods Case 12- What Are We Really Worth; Valuation of Common Stock Case 13- The Lazy Mower: Is It Really Worth It?; Estimating Cash Flow-New Project Analysis Case 14- If the Coat Fits, Wear it; Replacement Project Analysis Case 15- The Dilemma at Day-Pro; Comparison of Capital Budgeting Techniques Case 16- Too Hot to Handle; Capital Budgeting Case 17- Flirting with Risk; Risk and Return Case 18- I Wish I Had a Crystal Ball; Real Options and Capital Budgeting Case 19- Can One Size Fit All?; Determining the Cost of Capital Case 20- We Are Not All Alike; Divisional Costs of Capital Case 21- Where Do We Draw the Line?: Marginal Cost of Capital and Capital Budgeting Case 22- EVA ? Does It Really Work?; Economic Value Added (EVA) Case 23- It’s......

Words: 739 - Pages: 3

Premium Essay

Pro Forma

...FINANCIAL STATEMENT OVERVIEW ASSIGNMENT # 3 Members: Zhishuang Liu Siyi Shang Qihui Wu Anqi Li Context 1. Assumptions 2 2. I/S Pro Forma 2 1.1 Interest Income 2 1.2 Net Interest Income Margin 2 1.3 Provision for Loan Losses 5 1.4 Net Income Margin 6 1.5 Tax Rate 6 1.6 Non-interest income and Non-interest expense 7 3. B/S Pro Forma 8 3.1 ROA and ROE 8 3.2 The Accounts change according to the Interest Income and Interest Expense 9 3.3 The Other Asset and Liability Accounts 11 3.4 Shareholders’ Equity Forecast 12 3.5 Retained earnings 13 4. Cash Flow Statement Pro Forma 15 1. Assumptions (1) Interest Income grows at a certain rate every year. (2) There is no issue of new shares (3) There are tendencies of the ratios, such as net interest income margin, net income margin, return on asset, return on equity, etc., that could be used for forecasting. (4) Simplify the accounts of Balance Sheet, Income Statement and Cash Flow Statement. * 2. I/S Pro Forma Interest Income Graph 2-1 Interest Income Graph 2-1 shows the total interest income of Orrstown from year 2006-2013. As it takes a longer time for small financial institutions to react on the financial crisis, the negative interest income of orrstown showed in year 2012 and 2013. Because there would be little chance of any big financial crisis in the following five years, it is reasonable to take outliers. Take the average of the annual......

Words: 1472 - Pages: 6

Premium Essay

Cash Flow Analysis

...1 Cash Flow Analysis Signal Cable Company When Jay Smith took the job of Assistant to the President, two years ago, things were going rather well at the Signal Cable Company. The company was on an expansionary path and had branched into the fiber optics business. The prospects looked good and the economy was strong. The threat of competition was not too severe. Due to the expectation of increased demand for fiber optic communications, the company had established two additional manufacturing facilities, and significantly increased its inventory. Signal Cable had enjoyed quite a run up in profits over the past few years. However, when the accounting statements were prepared for the current year, the results showed a lower net profit margin. More importantly, there was a severe drop in the cash balance of the company and the stock price had recently fallen from $7 to $5.50 per share. Jay knew that the shareholders would be very concerned and possibly irate. He was also sure that his boss, Joe Mathis, would have to 2 Case 1 Signal Cable Company come up with some feasible answers and suggestions as to how the liquidity problems could be alleviated. This concern was primarily important since the firm had been expecting to raise some short-term capital in the immediate future. Jay's expectations were fulfilled when Joe called him up and asked him to prepare a report explaining the financial condition of the irm. Table I and 2 present......

Words: 722 - Pages: 3

Premium Essay

Financial Statements and Cash Flow Analysis

...Chapter 2 Mini Case: “Financial Statement and Cash Flow Analysis” Jennifer L. Hatch Professor Edward Strafaci Advanced Financial Management January 28, 2015 Chapter 2 Mini Case: “Financial Statement and Cash Flow Analysis” Introduction According to the mini case, Jaeden Industries has provided their account balances as of December 31, 2010. In order to determine the company’s free cash flow, liquidity, debt and profitability ratios, and market ratios, the following are required: dividend payout ratio of 25%, tax rate of 34%, stock price on December 31, 2009 was $42.39 and the stock price on December 31, 2010 was $56.82. Below are the calculations required in order to obtain a cash flow analysis on Jaeden Industries. Jaeden’s Free Cash Flow Free cash flow involves the following acronyms that are to be applied to the first party of the formula: net operating profits after taxes (NOPAT), earning before interest and taxes (EBIT), T = corporate tax rate, and operating cash flow (OCF). In order to calculate the free cash flow (FCF), two steps are required. The first step is to calculate the OCF, and then the free cash flow can be determined. Operating Cash Flow OCF = [EBIT x (1 – T)] + Depreciation OCF = [$13,119,000 x (1 - .34) + $700,000 OCF = [$13,119,000 x .66] + $700,000 OCF = $8,658,540 + $700,000 OCF = $9,358,540 Free Cash Flow In order to determine the second part of the calculation, the following information is required: change in gross......

Words: 1673 - Pages: 7

Premium Essay

Analyzing Pro Forma Statement

...Analyzing Pro Forma Statements Kaleah S. Daniels FIN/571 Analyzing Pro Forma Statements Pro forma statements are prepared to forecast financial results that are based on anticipated future projects or events. It is design to show projection of revenues, cash flows deducting the estimated expenses or costs for a particular business plan. Pro forma statements assist financial managers to plan accordingly, in terms of the company’s financial needs. How much financing is needed and when it is needed can be determined by acquiring an estimate of the company’s future balance sheet accounts and income statement. Hence, the purpose of the Pro forma analysis is to forecast the company’s financial statements under a particular condition (Parrino et al., 2012). XYZ Company, INC. is planning for business expansion in the coming years. This paper will discuss and analyze pro forma statements of five year projections created. The company’s income statement displays that the break in the current year occurred when; “Net sales equals $1,747,698, Gross profit equals $697,428 and Total operating expenses equals $285,850” (UOP, 2014). XYZ’s “management expects sales to increase by 10 percent for the coming year. Assuming that the financial statement accounts vary directly with changes in sales and that management has no financing plan at this time” (Parrino, 2012, pg. 613). Using the data from the current statement (income & balance sheet) we are able to calculate, 1)......

Words: 670 - Pages: 3

Premium Essay

Cash Flow Analysis – Signal Cable Company

...TOPIC : CASH FLOW ANALYSIS – SIGNAL CABLE COMPANY Introduction The Signal Cable Company is a cable manufacturer for analog and digital interconnects, speaker, video and home theater cables. It is located in Tarrytown, New York. The company is well known for “highest standard in quality and customer service” and their “superior design” and “No-Hype approach resulted in one of the best price/performance ratio in the industry”. After Signal Cable had enjoyed quite a run up in profits over the past few years, the management decided to enter in the fiber optic communications business. The market was growing, the demand increased and the competition was not too severe. Eventually, the company established two additional manufacturing facilities and increased its inventory to meet the needs. Current Situation Despite Signal Cable had enjoyed profits in past few years, the accounting statements showed a lower net profit margin. Furthermore, the cash balance and the stock price had fallen recently. Jay Smith, Assistant to the President, has now the challenge to prepare some feasible answers and suggestions for his boss, Joe Mathis, who has to inform the shareholders about the current situation. Questions of the Case Study 1. Why has the stock price fallen despite the fact that the net income has increased? A company’s stock price is depend on its demand and supply in the stock market. There are many factors to influence an investor’s decision of buying or selling the......

Words: 1585 - Pages: 7

Premium Essay

Cash Flow Forecasting

...- Assignment 8 – Cash Flow Forecasting Assignment Objective To be able to create a cash flow forecast Scenario Dial A Pizza is hoping to go to the bank soon to ask for initial funding for the business. In order to help them achieve the loan from the bank, they would like you to help them to create a 12 month cash flow forecast. Assignment Outcomes P6 – prepare an annual cash flow forecast using monthly data M3 – analyse the implications of regular and irregular cash inflows and outflows for a business organisation D1 – evaluate the importance of cash flow and break even for the effective management of business finance |Task |Grading Criteria |Evidence | |Task 1 |P6 |Cash flow forecast | |Using the data provided, produce a cash flow forecast. This must show the: | | | |Cash inflows (capital, sales, loans) | | | |Cash outflows......

Words: 354 - Pages: 2

Free Essay

Fin 370 Week 4 Cash Flow Analysis

...Cash Flow Analysis Instructions: Analyze the case study, "Frank Smith Plumbing." Analyze the "Frank Smith Plumbing's Financial Statement" spreadsheet. Compare the cost of the truck to the cash flow records Compile your calculations in a Microsoft® Excel® document Develop a 1,050-word analysis and include the following: • Explain why limited leverage is good for business. Show the profitability of the project so that Stephanie can convince her father to purchase the truck by borrowing money. • Explain how Stephanie should convince her mother that it is inappropriate to call the bank manager and his wife for assistance in getting the loan approval? • Analyze whether the investment in the truck is profitable. • Explain whether it is more beneficial for Frank to close his business. • Explain what you would do in this same situation. Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignments. Supporting Material: Frank Smith Plumbing Case Study Frank Smith Plumbing Case Study Excel Spreadsheet Cash Flow Analysis Grading Guide Find The Complete Answers just a click away FIN 370 Complete Answer About Author This article covers the topic for the University Of Phoenix FIN 370 Week 4 Cash Flow Analysis the author is working in the field of education from last 5 years. This article covers the basic of FIN 370 Complete Answer from UOP. Other topics in the class are as follows: FIN 370 WEEK 4 CASH FLOW......

Words: 279 - Pages: 2

Premium Essay

Pro Forma Cash Flow Budget

...Analysis of different alternatives available to Guillermo Analysis of different alternatives available to Guillermo Guillermo's Furniture Store Scenario provides the expedient case study for studying the concept of financial principle in the competitive economic environment. The current paper discusses the approach of financial management with correct application of ideas to create value and economic efficiency through analysis of financial transactions to establish the position of Guillermo in market. Current Project, High-Tech Project and the Broker Project are three alternatives available to the company to invest in right project. Financial principles, financial markets, and business ethics form a foundation for the financial decisions that managers routinely make. Guillermo’s case study shows that the arrival of new competitor from oversees have put unexpected challenges on the financial condition of the company. Guillermo has three alternatives to approach the business with new insight and action. Incremental costs and benefits are the basis for choices among alternatives where transactions have at least two sides, with each party considering their self-interest. Concept of an opportunity cost can be applied to differentiate between the value of one action and the value of the best alternative. He can invest in new technology and make furniture automatically, accurately and with almost no labor costs. So, developing expertise can create value. Other option is...

Words: 1462 - Pages: 6

Premium Essay

Cash Flow Forecasting

... Cash Flow Forecasting Essential Capital Markets Books in the series: Cash Flow Forecasting Corporate Valuation Credit Risk Management Finance of International Trade Mergers and Acquisitions Portfolio Management in Practice Introduction to Project Finance Syndicated Lending Cash Flow Forecasting Edited by Andrew Fight A MSTERDAM • BOSTON • HEIDELBERG • LONDON • NEW YORK • OXFORD P ARIS • SAN DIEGO • SAN FRANCISCO • SINGAPORE • SYDNEY • TOKYO Butterworth-Heinemann is an imprint of Elsevier Butterworth-Heinemann is an imprint of Elsevier Linacre House, Jordan Hill, Oxford OX2 8DP 30 Corporate Drive, Suite 400, Burlington, MA 01803 First published 2006 Copyright © 2006, Andrew Fight. All rights reserved. Note The materials contained in this book remain the copyrighted intellectual property of Andrew Fight, are destined for use in his consulting activities, and are to be clearly identified as copyrighted to him. Andrew Fight has asserted his right under the Copyrights, Designs, and Patents Act 1988, to be identified as author of this work, and confirms that he retains ownership of the intellectual property and rights to use these materials in his training courses and consulting activities. No part of this publication may be reproduced in any material form (including photocopying or storing in any medium by electronic means and whether or not transiently or incidentally to some other use of this publication) without the written......

Words: 70546 - Pages: 283

Premium Essay

Solution Case 3-1 Cash Flow Analysis – Orthodontic Centers of America

...CASE 3-1 Cash Flow Analysis – Orthodontic Centers of America 1. Actual cash collection for year 1998 to 2000:   | 2000 | 1999 | 1998 | Total Receivables | 3.535.000 | 87.563.000 | 66.477.000 | net change | (84.028.000) | 21.086.000 | 66.477.000 |   |   |   |   | Patient prepayments | - | - | 4.326.000 | net change | - | (4.326.000) | 4.326.000 |   |   |   |   | Net Revenue | 268.836.000 | 226.290.000 | 171.298.000 | Less: change in account receivable | 84.028.000 | (21.086.000) | (66.477.000) | Plus: change in advances | - | (4.326.000) | 4.326.000 | Actual Cash Collections | 352.864.000 | 200.878.000 | 109.147.000 | 2. (i) Comparison of cash collection with revenue reported for each year:   | 2000 | 1999 | 1998 | Cash Collections | 352.864.000 | 200.878.000 | 109.147.000 | Reported Revenue | 268.836.000 | 226.290.000 | 171.298.000 | % Change | 31,26% | -11,23% | -36,28% | Difference | 84.028.000 | (25.412.000) | (62.151.000) | (ii) Comparison of cash collection with revenue using pre-Januay 1, 2000 recognition method:   | 2000 | 1999 | 1998 | Cash......

Words: 1039 - Pages: 5