Porter’s Problems Co.
Basic Information
For Year Ended December 31, Year 2
Key Assumptions:
Sales Information: Sales Numbers Trasposed for Copying
Current Assets
Cash $30,176
Accounts Receivable $413,250
Raw Materials Inventory $69,884
Finished Good Inventory $66,152
Total Current Assets $579,462
Property, Plant, and Equipment
Land $250,000
Collection Information: Building $1,500,000
Equipment $1,500,000
Accumulated Depr – Equipment ($875,000)
Total PPE $2,375,000
Total Assets $2,954,462
Liabilities
Accounts Payable $131,250
Bonds Payables $1,000,000
Total Liabilities $1,131,250
Stockholder’s Equity
Manufacturing Information: Common Stock (100,000 shares outstanding) $1,750,000
Retained Earnings $73,212
Total Stockholder’s Equity $1,823,212
Total Liabilities and Stockholder’s Equity $2,954,462
Direct Material Information:
Payment information:
Direct Labor Information:
Manufacturing OH Information:
Selling and Administrative Expense Information:
Fixed S&A Expenses per year:
Raw Data
Assets
Liabilities and Stockholder’s Equity
Porter’s Projects Co.
Balance Sheet
As of December 31, Year 1
Porter’s Problems Co.
Basic Information
For Year Ended December 31, Year 2
Cash Flow and Investment Information:
Requirements
Dividends
Planned Expansion (Purchase of Equipment)
Debt Information:
Common Stock information:
Miscellaneous Information:
Porter’s Problems Co.
Production Budget
For the Year Ended December 31,Year 2
Year 3
Q1 Q2 Q3 Q4 Year 2 Q1
Quarter
Porter’s Problems Co.
Direct Materials and Cash Disbursements for Materials Budgets
For Year Ended Dec. 31, Year 2
Year 3
Q1 Q2 Q3 Q4 Year 2 Q1
Quarter
Raw Materials Budget
Porter’s Problems Co.
Direct Labor Budget
For Year Ended December 31, Year 2
Q1 Q2 Q3 Q4 Year 2
Quarter
Porter’s Problems Co.
Manufacturing Overhead Budget
For Year Ended December 31, Year 2
Q1 Q2 Q3 Q4 Year 2
Quarter
OH Budget
Porter’s Problems Co.
Selling and Administrative Expense Budget
For Year Ended December 31, Year 2
Q1 Q2 Q3 Q4 Year 2
Quarter
Porter’s Problems Co.
Cash Budget
For Year Ended December 31, Year 2
Q1 Q2 Q3 Q4 Year 2
Quarter