Skip to content
Solved Assignments

Financial Planning and Forecasting for Rologene Company: Module 2 Problem Set

A financial planning and forecasting assignment focused on Rologene Company.

Preview 3 of 9 pages

See the first 3 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Financial Planning and Forecasting for Rologene Company: Module 2 Problem Set Problem Set for Module 2 The Rologene Company 200X Balance Sheet Assets Liabilities Accounts Payable 35,000 Cash 40,000 Accruals 2 5,000 Marketable Securities 10,000 Current Note Payable 20,000 Accounts Receivable 70,000 Total Current Liabilities 80,000 Inventory 80 ,000 Bonds 2 4 0,000 Total Current Assets 200,000 Total Liabilities 320,000 Property Plant & Equipment 22 0 ,000 Retained Earnings 40,000 Total Assets 420,000 Common Stock 6 0,000 Total Liabilities and Equity 420,000 Other Information : • 200X sales = $800,000 • 200X profit margin = 5% • 200X payout ratio = 35% Assumptions for 200Y : • Expected change in sales (ΔS) = $200,000 • 200X profit margin and payout ratios will be in effect in 200Y • Property, Plant, and Equipment (fixed assets) are expected to increase by $90,000 • Depreciation expense for 200Y = $20,000 • Company holds marketable securities in a semi - permanent savings account • The Current Note Payable will not be rolled - over and is to be paid off in year 200Y 1. Prepare the EFN equation for the Rologene Company using the information above. Show your work, label your computations and clearly mark your answer. To calculate the External Financing Needed (EFN), we use the following equation: Given the data, here's how we break it down:

  2. Page 2
  3. Page 3
    Read page 3 as text

    1. Determine the Change in Assets and Liabilities : The EFN is primarily driven by changes in assets and liabilities. However, in this case, we assume the company's sales and other operations are growing, so we consider the growth rate in assets and liabilities. We need to assess the current assets and current liabilities to calculate the EFN. Step - by - Step: • Total Assets = $420,000 • Total Liabilities = $320,000 • Equity (Retained Earnings + Common Stock) = $40,000 + $60,000 = $100,000 So, the total equity is $100,000. • Current Assets = $200,000 (from cash, marketable securities, accounts receivable, inventory) • Current Liabilities = $80,000 (from accounts payable, accruals, current note payable) Now, if the company needs to maintain a proportional relationship between assets and liabilities, we need to calculate the growth required. 2. EFN Calculation : If the company plans to increase its assets (say, due to projected sales growth), the EFN formula would look like this: Assuming the company expects a sales growth rate of "X%" (not provided, but usually derived from projections), this will affect both assets and liabilities. Without the specific growth rate, we can't calculate EFN exactly but the general formula would be: If we had a projected growth rate, say 10%, we would multiply the current assets and liabilities by 1.10 and then subtract from the current liabilities and equity.

6 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document
See all

Study this document with CramX

Once it is in your library, every tool can work from it.