Pro forma financial statements
Not what you're looking for?
Below are the pro forma financial statements for 2010 of your company. The owners of the company have grown sales by having a very generous credit policy. The yearend A/R balance will be $2,500,000 which is about 90 days of sales. There will also be a Notes Payable bank loan of $1,900,000 outstanding at the end of the year. The company's banker said it would be very difficult for the bank to lend the company that much, because the company is acting like a bank by financing customers' purchases.
The owner would like to see how changing the credit policy would affect the need for a loan. They would like to lower the year end A/R balance to 45 days of sales. The owners realize this will cause the sales to fall. They predict the sales will fall 4% to $9.6 million for the year. GA&S, fixed assets, long term debt, common stock and depreciation will not change. Inventory, cost of goods sold, and A/P will remain the same percent of sales under either plan. The tax rate is 30%. The minimum cash balance is $250,000.
Pro form income statement for 2010 (in thousands)
Sales 10,000
COGS 6,400
GM 3,600
GA&S 1,600
Dep 400
Int 250
Taxable income 1,350
Tax 405
Net income 945
Pro forma balance sheet as of Dec 31, 2010
Cash 250
A/R 2,500
Inv 1,600
TCA 4,350
FA 12,000
Acc. Dep 4,800
NFA 7,200
TA 11,550
A/P 200
N/P 1,900
TCL 2,100
LTD 1,225
CS 1,000
RE 7,225
TL&E 11,550
Create a new pro forma for 2010 using the new credit policy with the lower sales estimate.
Purchase this Solution
Solution Summary
The solution explains how to prepare a new pro forma for 2010 using the new credit policy with the lower sales estimate.
Purchase this Solution
Free BrainMass Quizzes
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.