Tài liệu Benninga 2006: Mẫu bảng Excel với dòng tiền và báo cáo tài chính doanh nghiệp - Pdf 85

PRETTY ME FINANCIAL STATEMENTS
Assets Liabilities and equity
Current assets Current liabilities
Cash Accounts payable (Suppliers) 25,000
Initial Investment 1,000,000 Accounts payable (Distribution) 7,200
Cash Income 645,000 Accounts payable (Advertising) 10,000
Salaries -200,000
Building purchase -400,000 Long-term liabilities
Office equipment -20,000
Computer -10,000 Mortgage 373,333
Suppliers -155,000 Operating machine loan 300,000
License -5,000
Advertising -40,000
Distribution -36,000
Principal -126,667
Rent -360,000
Interest rate¹
-54,533
Cash at end of period 237,800
Prepaid expenses (rent) 288,000
Prepaid expenses (license) 2,500
Payments receivable (clients) 55,000
Inventory 25,000
Fixed assets
Computers 10,000 Equit
y
Office equipment 20,000
Building purchase 800,000 Equity 1,000,000
Operating machine 400,000 Accumulated retained earnings 122,767
Total assets 1,838,300 Total liabilities and equit
y 1,838,300

Interest
1 400,000 100,000 8,000
Total 100,000 8,000
Total: Loan + Mortgage 126,667 31,266.67
Profit and loss for the period
Sales 700,000
Salaries -200,000
Suppliers -180,000
Distribution -43,200
Rent -72,000
Advertising -50,000
Interest rate -54533
License -2500
Inventory 25,000
Profit 122,767
Dividends 0
Retained earnings 122,767


Nhờ tải bản gốc

Tài liệu, ebook tham khảo khác

Music ♫

Copyright: Tài liệu đại học © DMCA.com Protection Status