[go: up one dir, main page]
Scribd
Upload
57 views7 pages

FA Practice Excel

1. The balance sheet shows total assets of $98,400, total liabilities of $30,200, and total equity of $68,200. 2. Transactions increased cash by $18,900, decreased inventory by $7,500, and increased equity by $18,900. 3. After transactions, assets equal liabilities plus equity, indicating the accounting equation balances.

Uploaded by

Swati Porwal
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
57 views7 pages

FA Practice Excel

1. The balance sheet shows total assets of $98,400, total liabilities of $30,200, and total equity of $68,200. 2. Transactions increased cash by $18,900, decreased inventory by $7,500, and increased equity by $18,900. 3. After transactions, assets equal liabilities plus equity, indicating the accounting equation balances.

Uploaded by

Swati Porwal
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
You are on page 1/ 7

Q1 Assets Liabilities

Transactions
+ - +
Cash 12000
Inventory 95000
Items 13000
Loan 40000
Equity

120000 0 40000
Net 120000
Check

FA PG 29 - QS - 1-10

1c 1d
2a 2b
3g 3a
4h 1f
5b 2c

FA PG 33
Revenue Expenses
20000
33000 12000
22000 8000

55000 40000
15000

Statement of Retained Earnings


3000
15000
-13000
5000

Sales Goals
Growth rate among, 2 wheelers, 4 wheelers, 3 wheelers
2004-05 2005-06 2006-07
4W 1209876 1309300 1545223
2W 6529829 7608697 8466666
3W 374335 434423 556126
2004-05 2005-06 2006-07
4W 0.0821770165 0.180190177957687
2W 0.1652214782 0.112761620025084
3W 0.1605193209 0.280148610916089

Market Control Cost


16.45%
Passenger Segment Selling Price
Dealer Margin
Capacity Constraint 50000 Cash paid up front
Manufacturing margin
Cumulative Sales Revenue per car
1 16.45% Expense per Car
2009-2010 2044147.6974 Profit

4W 2044147.6974
2W 8998231.7104
3W 530498.008

58.8
17
24.2 494683.7427708
low cost 10 204414.76974
premium segment an 14.2

middle 800000 200000


18% 144000 36000
Population 1217700000
Middle Class 12% 146124000
No of middle class fa 29224800
Afford Nano 6429456
Maruti 800 1928836.8 30%
2W 3214728 50%
Interest Area
Nano 642945.6 10%
Indifferent 642945.6 10%
iabilities Equity Q2
Transactions
- + -
Equity
Merchandise
Equipment
Advance Rent
80000 Stock
Machinery

Cash
Check
Rent
Payment

0 80000 0
40000 80000 Net
Correct Check
2007-08 2008-09 2009-10
1777583 1838593 2044147.697
8026681 8419792 8998231.71
500660 491020 530498.008
2007-08 2008-09 Average
0.1503731 0.0343219 0.111765549 11.18%
-0.051967 0.0489755 0.068747974 6.87%
-0.099736 -0.019255 0.080419239 8.04%

Nano CX LX Maruti 800


100000 157808 181438 135000
2500 3945.2 4535.95
1000 1578.08 1814.38
15000 23671.2 27215.7
81500 128613.52 147871.97

7 3
61324.431

1000000 500000
180000 90000

1% 32147.28
5% 32147.28
64294.56
Assets Liabilities Equity
+ - + - + -
30000
18900 18900
12700 10700
1800
10700 10700
35000 27500

30000
2000
1800
18900 18900
7500

98400 30200 57100 29600 40700 0


68200 27500 40700
Correct

You might also like