Unit 5 Discussion

profileSkylerreybrasil
ProFormaBalanceSheet-Q3.xlsx

Pro Forma Balance Sheet

Pro Forma Balance Sheet
Report Item Quarter 1 Quarter 2 Quarter 3
Current Assets
Cash 1,100,000 2,071,359 3,068,031
+ 3 Month Certificate of Deposit 0 0 200,000
+ Finished Goods Inventory 0 0 45,282
Long Term Assets
+ Net Fixed Assets 600,000 575,000 1,150,000
= Total 1,700,000 2,646,359 4,463,313
Debt
+ Emergency Loan 0 0 0
Equity
+ Common Stock 2,000,000 3,000,000 4,000,000
+ Retained Earnings -300,000 -353,641 463,313
= Total 1,700,000 2,646,359 4,463,313
End of Worksheet