Question
You are preparing to discuss borrowing needs with your bank's loan officer who asks you to prepare pro-forma financial statements. Below are the financial statements
You are preparing to discuss borrowing needs with your bank's loan officer who asks you to prepare pro-forma financial statements. Below are the financial statements for the year just ended. Your sales department is projecting a 28% increase in sales. Days sales outstanding are expected to improve to 45 days. With respect to inventory and accounts payable, assume that purchases will be $9,574,400 and cash payments will be $8,616,960. The Company expects to invest $1,986,000 (net of depreciation) to expand its storage capacity and achieve scale savings. Accordingly, gross profit margins are expected to be 32% in the future. Other expenses are expected to remain the same percentage of sales. The retention ratio is 45%.
For ease of calculation, assume interest expense remains the same.
Cash 400,000 Sales 10,000,000 Accounts Receivable 1,400,000 Cost of Sales 8,000,000
Inventory 1,800,000 Gross Profit 2,000,000 Total current Assets 3,600,000 Operating Expense 900,000
Fixed Assets 1,400,000 EBIT 1,100,000 Total Assets 5,000,000 Interest Exp 100,000
EBT 1,000,000 Accounts Payable 1,200,000 Tax (30%) 300,000 Long-term Debt 1,000,000
Net Income 700,000 Total Debt 2,200,000 Common Stock 1,300,000 Retained earnings 1,500,000 Total Debt and Equity 5,000,000
In preparing your forecast financial statements, your forecast for cost of sales will be ?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started