Answered step by step
Verified Expert Solution
Link Copied!

Question

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 31% 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 $10,807,500 and cash payments will be $9,726,750. The Company expects to invest $1,701,000 (net of depreciation) to expand its storage capacity and achieve scale savings. Accordingly, gross profit margins are expected to be 25% in the future. Other expenses are expected to remain the same percentage of sales. The retention ratio is 53%.

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

Sales

13,100,000

Cost of Sales

9,825,000

Gross Profit

3,275,000

Operating Expenses

EBIT

Interest Expense

EBT

Tax (30%)

Net Income

In preparing your forecast financial statements, your forecast for Net Income 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