0% found this document useful (0 votes)
23 views17 pages

Financial Data Input and Analysis Guide

Uploaded by

Thư Trần
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views17 pages

Financial Data Input and Analysis Guide

Uploaded by

Thư Trần
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

INPUT DATA INTO THE YELLOW CELLS

ASSETS Beginning balance LIABILITIES AND EQUITY


[Link] and cash equivalents 375 [Link]-term loans
[Link] from customers 110 [Link] to suppliers
[Link] 200 3. Long-term loans
[Link] cost of Fixed assets 800 4. Owner's equity
Accumulated depreciation and amortization -25
TOTAL ASSETS 1460 TOTAL LIABILITIES&EQUITY
1. The total amount from sales (NOT SUBJECT TO SCT) excluding VAT each month
*The total amount from sales (SUBJECT TO SCT) excluding VAT each month
* The percentage of the total amount paid by the customers during the month of sales
* The remaining paid after i month. And i equals
2. Total amount payable to domestic suppliers excluding VAT
* The percentage of the total amount paid by the customers during the month of purchases
* The remaining paid after i month. And i equals
3. The amount of basis for calculating import duty which is NOT SUBJECT TO SCT)
* The percentage of the basis paid during the month of purchases
* The remaining paid after i month. And i equals
[Link] costs (excluding raw materials and depreciation)
[Link] costs attributed to selling expenses
Attributed to general & administrative expenses.
6. Depreciation of fixed assets attributed to direct cost
*Attributed to selling expenses
*Attributed to general and administrative expenses
7. Outside purchasing services cost (excluding VAT)- attributed to selling expenses
Attributed to general & administrative expenses.
* Paid in the first month
* Paid in the second month
* Paid in the third month
8. Inventories at the end of the quarter
9. Monthly rate of the short-term loan
* Paid in the first month
* Paid in the second month
* Paid in the third month
10. Annual rate of the long-term loan
* Paid in the first month
* Paid in the second month
* Paid in the third month
11. Payment of short term loan principal at the end of the month
The month when it is paid
12. Account receivable from beginning period is paid
* The month when it is paid
13. Account payable from beginning period is paid
* The month when it is paid
14. Short term investment
* Paid in the first month
* Paid in the second month
* Paid in the third month
15. Withdrawals of the short term investment
* Collected in the first month
* Collected in the second month
* Collected in the third month
16. Disposal of a fixed asset (excluding VAT) at the end of the period
* Collected in the first month
* Collected in the second month
* Collected in the third month
Net book value
The historical cost
Is the fixed asset subject to VAT? (Yes=1, No=0)
[Link] rate (credit method)
*Percentage of VAT from importation paid in the month of importation
*the remaining is paid after i month, and i equals
*Percentage of VAT payable paid in the month of calculation
*the remaining is paid after i month, and i equals
[Link] rate
* The amount of SCT calculated from raw material purchases is allocated to goods sold.
* The percentage of SCT paid in the month of calculation
* the remaining is paid after i month, and i equals
[Link] tariff
* The amount of import duties paid in the month of importation
* the remaining is paid after i month, and i equals
20. CIT rate
* Paid in the first month
* Paid in the second month
* Paid in the third month
21. Another tax attributed to general & administrative expenses
* The month when it is paid
22. Capital contributions by fixed assets from shareholders at the end of the period
Beginning balance
200
150
300
810

1460
400
300
30%
2
553
40%
2
0
0%
0
30
12
8
12
8
0
10
0
11
11
11
300
1%
2
2
2
15%
0
0
11.25
15
3
60
2
140
3
100
100
0
0
95
0
95
0
17
0
0
17
18
52
1
10%
0%

0%
1
50%
50
0%
1
10%
0%
1
20%
5
5
5
10
2
0
3.2 The Income Statement of X

1. Sales 1800
2. Deductions 0
Sales discounts
Sales rebates
Sales Returns
3. Net sales 1800
[Link] of goods sold 1535
5. Gross profit/loss 265
[Link] income 0
7. Financial expenses 22.25
In which: Loan interest expenses 17.25
8. Selling expenses 90
9. General and administrative expenses 34
[Link] operating profit/loss 118.75
11. Other income 17
12. Other expenses 18
13. Other profit/loss -1
14. Profit/loss before tax 117.75
[Link] income tax 23.55
[Link]/loss after tax 94.2
(The total amount from sales (NOT SUBJECT TO SCT)
excluding VAT each month + The total amount from
sales (SUBJECT TO SCT) excluding VAT each
month /(1+50%))*3
3.1 Taxes
Output VAT amount each month (the 1st and the 2nd month) 70
Deducted input VAT amount 56.3
VAT amount payable (the 1st and the 2nd month) 13.7
Output VAT amount (the 3rd month) 71.7
Deducted input VAT amount 56.3
VAT amount payable (the 3rd month) 15.4
Output SCT amount each month 100
Deducted input SCT amount 50
SCT amount payable 50
Profit/(loss) before tax 117.75
CIT
23.55
3.3 Cash flows

Items
Month 1 2 3
[Link] inflows from: 231 386 788.7
[Link] in the month m 231 231 231
[Link] in the month m+i 0 539 1078
[Link] of short-term investment 0 95 0 0
4. Disposal of fixed assets 0 0 18.7 0
[Link] in receivables from customers 0 60 0
[Link] outflows from: 411.32 385.02 906.25
1. Raw material purchases (month m) 243.32 243.32 243.32
Raw material purchases (month m+i) 0 364.98 729.96
2. The imported raw material (month m) 0 0 0
The imported raw material (month m+i) 0 0 0
[Link] costs 30 30 30
[Link] costs 20 20 20
[Link] purchasing services 11 11 11 0
[Link]-term loan interest 2 2 2 0
[Link]-term loan interest 0 0 11.25 0
8. Short-term investment 100 0 0 0
[Link] duty payment (month m) 0 0 0
Import duty payment (month m+i) 0 0 0
[Link] from importation (month m) 0 0 0
VAT from importation (month m+i) 0 0
[Link] amount payable (month m) 0 0 0
VAT amount payable (month m+i) 13.7 13.7 15.4
[Link] amount payable (month m) 0 0 0
SCT amount payable (month m+i) 50 50 50
[Link] 5 5 5 8.55
[Link] taxes 0 10 0 0
15. Payment of short-term loan principal 0 0 15
16. Decrease in payable to suppliers 0 0 140
Increases/Decreases in cash -180.32 0.98 -117.55
Beginning cash and cash equivalents 375 194.68 195.66
Ending cash and cash equivalents 194.68 195.66 78.11
3.4The Balance Sheet of X
ASSETS Beginning balance
A. CURRENT ASSETS 685
[Link] and cash equivalents 375
1. Cash 375
2. Cash equivalents
[Link]-term investments 0
1. Short-term Investments
2. Provision for devaluation of short-term investments
III. Accounts receivable 110
1. Receivable from customers 110
2. Prepayments to suppliers
3. Short-term inter-company receivables
4. Receivables according to the progress construction contracts
5. Other receivables
6. Provisions for bad debts
[Link] 200
1. Inventories 200
2. Provisions for devaluation of inventories
V. Other current assets 0
1. Short-term prepaid expenses
2. VAT to be deducted
3. Taxes and statutory obligations
4. Other current assets
[Link] TERM ASSETS 775
I. Long-term receivables 0
1. Long-term receivable from customers
2. Capital from subsidiaries
3. Long-term inter-company receivable
4. Other long-term receivables
5. Provisions for bad long-term receivables
II. Fixed assets 775
1. Tangible fixed asset 775
Historical costs 800
Accumulated depreciation -25
2. Financial leasehold assets 0
Historical costs
Accumulated depreciation
3. Intangible fixed asset 0
Initial costs
Accumulated amortization
4. Construction-in-progress
III. Investment property 0
Historical costs
Accumulated depreciation
[Link]-term investments 0
1. Investments in affiliates
2. Investment in associates, joint-ventures
3. Other long-term investments
4. Provisions for devaluation of long-term investments
V. Other long-term assets 0
1. Long-term prepaid expenses
2. Deferred income tax
3. Other long-term assets
TOTAL ASSETS 1460
LIABILITIES AND OWNERS' EQUITY Beginning balance
[Link] 650
I. Current liabilities 350
[Link]-term debts and loans 200
2. Payable to suppliers 150
3. Advances from customers
4. Taxes and other obligations to the State Budget
5. Payable to employees
6. Accrued expenses
7. Inter-company payables
8. Payable according to the progress construction contracts
9. Other payables
10. Provisions for short-term payables
II. Long-term liabilities 300
1. Long-term accounts payable to suppliers
2. Long-term inter-company payables
3. Other long-term payable
4. Long-term debts and loans 300
[Link] income tax payables
6. Provisions for unemployment allowance
7. Provisions for long-term payables
[Link]' EQUITY 810
[Link] owners' equity 810
[Link] 810
2. Share premiums
3. Other sources of capital
4. Treasury stocks
5. Differences on asset revaluation
6. Foreign exchange differences
7. Business promotion fund
8. Financial reserved fund
9. Other funds
[Link] earnings
[Link] investment fund
II. Other sources and fund 0
1. Bonus and welfare fund
2. Sources of expenditure
3. Fund to form fixed assets
TOTAL LIABILITIES AND OWNERS' EQUITY 1460
Ending balance
1506.11
78.1099999999999
78.1099999999999

1128
1128
0

300
300

0
0

697
0

697
697
748
-51
0

0
0

2203.11
Ending balance
1298.91
998.91
185
739.96

73.95

300

300

904.2
904.2
810
94.2

2203.11
CASH FLOWS STATEMENT (Direct method)
I. Cash flows from operating activities
1. Gains from sales of goods and service provisions and other gains 1292
2. Payments to suppliers -1267.94
3. Payments to employees -150
4. Loan interests already paid -17.25
5. Payments for corporate income tax -15
6. Other gains
7. Other disbursements -137.4
Net cash flows from operating activities -295.59
II. Cash flows from investing activities
1. Purchases and construction of fixed assets and other long-term assets
2. Gains from disposal and liquidation of fixed assets and other long-term assets 18.7
3. Loan given and purchases of debt instruments of other entities
4. Recovery of loan given and disposals of debt instruments of other entities
5. Investments into other entities -100
6. Withdrawals of investments in other entities 95
7. Receipts of loan interests, dividend and profit shared
Net cash flows from investing activities 13.7
[Link] flows from financing activities
1. Gains from stock issuance and capital contributions from shareholders
2. Repayments for capital contributions and repurchases of stocks already issued
3. Short-term and long-term loan received
4. Loan principal amounts repaid -15
5. Payments for financial leasehold assets
6. Dividend and profit already paid to the owners
Net cash flows from financing activities -15
Net cash flows during the year -296.89
Cash and cash equivalent at the beginning of the period 375
Effects of fluctuations in foreign exchange rates
Cash and cash equivalent at the end of the period 78.11

CASH FLOWS STATEMENT (Indirect method)


I. Cash flows from operating activities
1. Profit/ (loss) before tax 117.75
2. Adjustments
Depreciation of fixed asset 60
Provisions
Gain/ (loss) from foreign exchange differences
Gain/ (loss) from investing activities 6
Loan interest expenses 17.25
3. Operating profit before changes of working capital 201
Increase/ (decrease) of accounts receivable -1018
Increase/ (decrease) of inventories -100
Increase/ (decrease) of accounts payable 653.66
Increase/ (decrease) of prepaid expenses
Loan interests already paid -17.25
Corporate income tax already paid -15
Other gains
Other disbursements 0
Net cash flows from operating activities -295.59
(Other parts are the same as those of the direct method)

You might also like