Financial Planning and Forecasting for Rologene Company: Module 2 Problem Set
- Finance
- 9 pages
- Shared May 2025
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.
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:
Page 2 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 documentMore Finance study materials
See all
Textbook GuidesSolution Manual For Investments, 12th Edition
Finance
314 pages161downloadsFeb 2025
Exam GuidesTest Bank for Principles of Managerial Finance, 8th Edition
Finance
851 pages158downloadsFeb 2025
Textbook GuidesSolution Manual for Financial Institutions Management: A Risk Management Approach, 8th Edition
Finance
486 pages154downloadsFeb 2025
Exam GuidesTest Bank for Principles of Managerial Finance, Arab World Edition
Finance
373 pages148downloadsFeb 2025
Textbook GuidesMultinational Financial Management, Study Guide, 6th Edition Solution Manual
Finance
278 pages146downloadsFeb 2025
Textbook GuidesFinancial Markets and Institutions, 7th Edition Solution Manual
Finance
194 pages136downloadsFeb 2025
Certification GuidesWiley Finra Series 3 Exam Review (2019)
Finance
253 pages131downloadsFeb 2025
Exam GuidesTest Bank For Essentials of Investments, 8th Edition
Finance
368 pages130downloadsFeb 2025
Study this document with CramX
Once it is in your library, every tool can work from it.

