Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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 33% 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 $11,118,800 and cash payments will be $10,006,920. The Company expects to invest $1,843,000 (net of depreciation) to expand its storage capacity and achieve scale savings. Accordingly, gross profit margins are expected to be 24% in the future. Other expenses are expected to remain the same percentage of sales. The retention ratio is 50%.

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 Accounts Payable will be ?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions