0% found this document useful (0 votes)
8 views28 pages

Cash Flow and Accounting Problems Analysis

Uploaded by

darel eman
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)
8 views28 pages

Cash Flow and Accounting Problems Analysis

Uploaded by

darel eman
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

PROBLEM 2 12/31/19 CASH

NR

CARRYING AMOUNT

12/31/20 I.R

CA
C
N

12/31/21 I.R

CASH

PROBLEM 3

CASH FLOW
Y1 Y2 Y3
₱ 750,000.00 P 1/1/2020 NR
I
₱ 563,486.00

12/31/2020 NR

12/31/21 NR

12/31/22 NR
CASH

PROBLEM 4 1/1/2020 NR
CASHFLOWS
Y1 Y2 Y3 5.46%
₱ 200,000.00 ₱ 200,000.00 ₱ 200,000.00 12/31/20 CASH

CASH SALES WILL BE RECORDED AS SALE


₱ 540,000.00

12/31/21 CASH

12/31/22 CASH

PROBLEM 5 1/1/2020 CASH


CASH FLOWS NR
Y1 Y2 Y3
₱ 300,000.00 ₱ 300,000.00 ₱ 300,000.00

12/31/20 \CASH

12/31/21 CASH
12/31/22 CASH

PROBLEM 6 1/1/2020 CASH


CASH FLOWS NR
Y1 Y2 Y3 AD
₱ 400,000.00
₱ 284,712.00

12/31/20 NR

12/31/21 NR

NR

CASH

PROBLEM -7 (12-5) 12/312015

PROBLEM 8 12 AND 15
1/1/2015 NR
NOTES - BAWAS MUNA BAGO DAGDAG
₱ 1,000,000.00
₱ 6,000,000.00
LAND ₱ 5,000,000.00
GAIN ₱ 2,000,000.00

CARRYING AMOUNT ₱ 6,000,000.00


C ₱ -
N ₱ 6,000,000.00

₱ 720,000.00
I.N ₱ 720,000.00

₱ 6,000,000.00
₱ 6,000,000.00
₱ -

₱ 806,400.00
I.N ₱ 806,400.00

₱ 7,526,400.00
I.R ₱ 1,526,400.00
NOTES ₱ 6,000,000.00

₱ 563,486.00
LAND ₱ 300,000.00
GAIN ₱ 263,486.00

₱ 56,348.00
IN ₱ 56,348.00

CA ₱ 609,835.00
C ₱ -
N ₱ 619,834.00

₱ 60,983.00
IN ₱ 60,983.00

CA ₱ 670,818.00
CA ₱ 670,818.00
N

₱ 67,082.00
IN ₱ 67,082.00

₱ 737,900.00
NR ₱ 737,900.00

₱ 540,000.00
SALES ₱ 540,000.00

₱ 200,000.00
IN ₱ 29,484.00
NR ₱ 170,516.00

CA ₱ 369,484.00 ₱ 369,484.00
C ₱ 179,826.00
N ₱ 189,658.00

₱ 200,000.00
IN ₱ 20,174.00
NR ₱ 179,826.00

CA ₱ 189,658.00
C ₱ 189,658.00
N ₱ -

₱ 200,000.00
INI ₱ 10,342.00
NR ₱ 189,658.00

₱ 100,000.00
₱ 720,549.00
SALES ₱ 820,549.00

₱ 300,000.00
IN ₱ 86,466.00
NR ₱ 213,534.00

CA ₱ 507,014.00 -₱ 507,015.00
C ₱ 239,157.00
N ₱ 267,857.00

₱ 300,000.00
IN ₱ 60,843.00
NR ₱ 239,157.00

CA ₱ 267,857.00
CA ₱ 267,857.00
N ₱ -

₱ 300,000.00
IN ₱ 32,143.00
NR ₱ 267,857.00

₱ 125,000.00
₱ 284,712.00
₱ 150,000.00
EQUIP ₱ 500,000.00
₱ 59,712.00

₱ 34,165.00
IN ₱ 34,165.00

CA ₱ 318,877.00 ₱ 318,877.00
C ₱ -
N ₱ 318,877.00

₱ 38,265.00
IN ₱ 38,265.00

CA ₱ 357,142.00
CA ₱ 357,142.00
N ₱ -

₱ 42,857.00
IR ₱ 42,857.00

₱ 400,000.00
NR ₱ 400,000.00

CASH FLOWS
Y1
P+I ₱ 500,000.00

Y0
₱ 2,922,000.00 ₱ 600,000.00
SALES ₱ 2,922,000.00

₱ 1,948,500.00
₱ 1,603,480.00
₱ 1,231,758.00
₱ 829,399.00
₱ 359,751.00
EARNED AMOUNT ₱ 6,720,000.00
P+I
₱ 20.00 ₱ 720,000.00
₱ 21.00 ₱ 806,400.00 ₱ 1,526,400.00
Y2 Y3 Y4 Y5 PV OF OA
₱ 500,000.00 ₱ 500,000.00 ₱ 500,000.00 ₱ 500,000.00 P+I ₱ 1,996,355.00

Y1 Y2 Y3 Y4 Y5 Y6
₱ 600,000.00 ₱ 600,000.00 ₱ 600,000.00 ₱ 600,000.00 ₱ 600,000.00 ₱ 600,000.00
NR

₱ 0.09 ₱ 175,365.00
₱ 0.09 ₱ 144,313.20
₱ 0.09 ₱ 110,858.22
₱ 0.09 ₱ 74,645.91
₱ 0.09 ₱ 32,377.59
₱ 537,559.92
PROBLEM 1

PROBLEM 2 FINANCIAL ACCOUNTING ( 10-9 ) pp.328

PROBLEM 3 FINANCIAL ACCOUNTING (10-7) pp 327


FOB DESTINATION POINT
FREIGHT COLLECT

FOB DESTINATION POINT


FREIGHT PREPAID

FOB SHIPPING POINT


FREIGHT COLLECT

FOB SHIPPING POINT


FREIGHT PREPAID

PROBLEM 4 PRACTICAL ACCOUNTING 16 1


PROBLEM 5 PRACTICAL ACCOUNTING 16 2

PROBLEM 6 PRACTICAL ACCOUNTING 16.3

PROBLEM 7 SINEND NI DIETHER

PROBLEM 8 PRACTICAL ACCOUNTING 16[6


PROBLEM 9 PRACTICAL ACCOUNTING 16[7

problem 10
PRACTICAL ACCOUNTING 16[10
GROSS
Accounts Recievable
sales

accounts recievable
cash

sales ret and allow


a.r

cash
sales discount
a.r

cash
ar
a.r freight amount

GROSS
Accounts Recievable
Sales

Acounts Recievable
Sales

Cash
sales discount
Accounts Recievable

cash
accounts recievable

SALES
FOB DESTINATION POINT Accounts Recievable
FREIGHT COLLECT Freight out
Sales
Allowance for freight Collect

COLLECT
Cash
Sales discount
Allowance for freight collect
Accounts recievable

FOB DESTINATION POINT SALES


FREIGHT PREPAID Accounts Recievable
Freight Out
Sales
Cash

COLLECT
Cash
Sales Discount
Accounts Receivable

SALES
FOB SHIPPING POINT Accounts Recievable
FREIGHT COLLECT Sales

COLLECT
Cash
Sales discount
Sales

FOB SHIPPING POINT SALES


FREIGHT PREPAID Accounts Recievable
Accounts receivable ( Freight )
Sales
Cash

COLLECT
Cash
Sales Discount
Accounts Recievable
Accounts Recievable (Freight)

Beg
credit sales
Beg
credit sales

ALLOWANCE FOR SALES RET


ALLOWANCE FOR DOUBTFUL
ammortize cost of a.r

TRADE ACCOUNTS RECEI


ALLOWANCE FORDOUBTFUL
CLAIMS RECIEVABLE
TOTAL CURRENT

RATE BALANCE
0.03 ₱ 180,000.00 ₱ 5,400.00 0/15
0.03 ₱ 108,000.00 ₱ 3,240.00 16/30
0.1 ₱ 90,000.00 ₱ 9,000.00 31/60
0.15 ₱ 72,000.00 ₱ 10,800.00 61/90
0.35 ₱ 54,000.00 ₱ 18,900.00 91/120
0.6 ₱ 36,000.00 ₱ 21,600.00 121/150
₱ 68,940.00

GROSS
(trade discounted) Accounts Receivable

Adjusted value

adjusted value

NRV
GROSS
Accounts Receivable

payment for freight prepaid ( reimburstment)


NRV

BEG
CREDIT SALES

RECOVERIES
NET
₱ 7,776,000.00 Accounts Recievable
₱ 7,776,000.00 Sales

₱ 130,000.00 freight accounts recievable


₱ 130,000.00 CHARGE cash

₱ 800,000.00 sales return and allow


₱ 800,000.00 a.r

₱ 6,537,600.00 cash
₱ 568,400.00 a.r
₱ 7,106,000.00 a.r ( freight amount)

₱ 7,106,000.00 cash
₱ 6,976,000.00 a.r
₱ 130,000.00 a.r freight amount
sales discount forfeited

total
+

NET
₱ 50,000.00 Accounts Recievable
₱ 50,000.00 sales

₱ 200,000.00 Accounts Recievable


₱ 200,000.00 Sales

₱ 196,000.00 cash
₱ 4,000.00 accounts recievable
₱ 200,000.00

₱ 50,000.00 cash
₱ 50,000.00 accounts recievable
sales discount forfeited
₱ 500,000.00
₱ 10,000.00
₱ 500,000.00
₱ 10,000.00

₱ 475,000.00
₱ 15,000.00
₱ 10,000.00
₱ 500,000.00

₱ 500,000.00
₱ 10,000.00
₱ 500,000.00
₱ 10,000.00

₱ 485,000.00
₱ 15,000.00
₱ 500,000.00

₱ 500,000.00
₱ 500,000.00

₱ 485,000.00
₱ 15,000.00
₱ 500,000.00

₱ 500,000.00
₱ 10,000.00
₱ 500,000.00
₱ 10,000.00

₱ 495,000.00
₱ 15,000.00
₱ 500,000.00
₱ 10,000.00

ACCOUNTS RECIEVABLE
₱ 1,300,000.00 ₱ 4,750,000.00 collection
₱ 5,400,000.00 ₱ 125,000.00 write off
₱ 1,825,000.00 A.R before allowance for doubtful accounts

ACCOUNTS RECIEVABLE
₱ 650,000.00 ₱ 75,000.00 sales return and allow
₱ 2,700,000.00 ₱ 40,000.00 write off
₱ 2,150,000.00 collections
₱ 1,085,000.00 ENDING

ENDING A.R ₱ 1,085,000.00


E FOR SALES RET ₱ 50,000.00
FOR DOUBTFUL ₱ 110,000.00
NRV ₱ 925,000.00

T ₱ 2,000,000.00
FORDOUBTFUL -₱ 100,000.00 TO GET THE NRV
₱ 300,000.00
₱ 2,200,000.00

AFDA
₱ 18,000.00 BEG
₱ 6,000.00 ₱ 3,000.00
₱ 53,940.00
₱ 68,940.00 END

ACCOUNTS RECEIVABLE
₱ 3,420,000.00 ACCOUNTS RECEIVABLE
₱ 500,000.00 sales return at gross
₱ 2,920,000.00
₱ 116,800.00 sales discount
₱ 2,803,200.00
₱ 100,000.00 ALLOWANCE FOR FREIGHT COLLECT
₱ 2,703,200.00
ACCOUNTS RECEIVABLE
₱ 2,800,000.00 SALES REVENUE Accounts Receivable
₱ 56,000.00 sales discount payment for freight prepaid
₱ 2,744,000.00
₱ 200,000.00
₱ 2,944,000.00

ACCOUNTS RECIVABLE
₱ 950,000.00
₱ 3,800,000.00 ₱ 50,000.00 WRITEOFF
₱ 250,000.00 SALES RETURN AND ALLOWANCES
₱ 80,000.00 ₱ 80,000.00 RECOVERIES
₱ 126,000.00 SALES DISCOUNT
₱ 3,024,000.00 COLLECTION
₱ 1,300,000.00
###
₱ 7,153,920.00

₱130,000.00
₱ 130,000.00

₱736,000.00
₱ 736,000.00

###
₱ 6,417,920.00
₱ 130,000.00

###
₱ 6,417,920.00
₱ 130,000.00
-₱ 558,080.00

###
₱800,000.00
###
###

₱ 49,000.00
₱ 49,000.00

₱196,000.00
₱ 196,000.00

₱196,000.00
₱ 196,000.00

₱ 50,000.00
₱ 49,000.00
₱ 1,000.00
NET ACCOUNTS RECEIVABLE
COUNTS RECEIVABLE ₱ 3,283,200.00
₱ 480,000.00 SALES RETURN
ADJUSTED ₱ 2,803,200.00
₱ 100,000.00 ALLOWANCE FOR FREIGGHT COLLECT
NRV ₱ 2,703,200.00
NET ACCOUNTS RECEIVABLE
counts Receivable ₱ 2,744,000.00
yment for freight prepaid ₱ 200,000.00
NRV ₱ 2,944,000.00

AFDA
write off ₱ 50,000.00 ₱ 100,000.00 BEG
₱ 80,000.00 recoveries
₱ 70,000.00 DAE
₱ 200,000.00 AFDA
₱ 10,000,000.00
₱ 2,500,000.00
₱ 1,000,000.00 Y1
₱ 7,000,000.00 ₱ 1,000,000.00
₱ 7.00

Dec-31 CASH ₱ 4,868,418.00


ACCUM ₱ 2,500,000.00
DOWNPAYMENT ₱ 1,000,000.00
EQUIPMENT ₱ 10,000,000.00
₱ 8,368,418.00
-₱ 1,631,582.00
Y2 Y3 Y4 Y5 Y6 Y7
₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00 ₱ 1,000,000.00
PV FACTOR OF OA
₱ 4,868,418.00

You might also like