Can someone help me do 20X3 Financial Statement Project. Need Adjustments worksheet, Income statement, Statement of comprehensive income ,Statement of owners' equity, Balance sheet, Statement of cash flows
Accounts receivable subsidiary reconciliation Sue's Paint Shop 28,380 Freeda's Fashions Carlos' Cars Peter's Planes Bob's Bank Earl's Earrings Greg's Garage 20,230 Paul's Go Karts 61,600 Total 110,210 Accounts payable subsidiary reconciliation Massive Building Supply Store Scott's Most Excellent Lumber The Computer Shop Ken's Tool Supply Company Total 7,470 7,470 Note: You must correct any errors in the second assignment (20X2) before you start working on this assignmnet. Business is good. To meet the delivery demands, Kline bought another truck. Not wanting to pay cash for the truck, though, she took advantage of the low interest rates offered by the Ford Dealership. Details on the purchase are shown below. General journal entry $ 10,300 Dividend declared by the Board of Directors during the year Market 5.60% Purchase of truck Coupon Purchase price 19,800 1.00% The term of the note is five years The note is due in monthly payments of principal and interest The truck has a ten year life and $5,000 of salvage value The payments on the note are made monthly. Convert the term of five years into monthly payments by multiplying it by 12, for a total of 60 payments. Divide the coupon interest rate by 12 to arrive at the monthly rate. Do not round the interest rate: Divide it by 12 and press the 1/YR button to input the result. Lumber Inventory Shop Supplies on Hand Tools Other 7,470 19,390 Detail below 14,1101 Purchases Journal Date January 1, 20X3 January 1, 20X3 January 1, 20X3 January 1, 20X3 May 1, 20X3 July 1, 20X3 August 1, 20X3 September 1, 20X3 December 1, 20X3 2,112 Vendor The Computer Shop Ken's Tool Supply Company Scott's Most Excellent Lumber Massive Building Supply Store Scott's Most Excellent Lumber Massive Building Supply Store Scott's Most Excellent Lumber Massive Building Supply Store Scott's Most Excellent Lumber Total 7,470 19,390 14,110 2,112 21,165 2,640 28,220 528 7,055 102,690 21,165 2,640 28,220 528 7,055 70,550 5,280 19,390 7,470 Table saw Lathe Cost 11,550 7,840 19,390 7,470 Useful Life Salvage 1,200 10800 Computer Sales Journal Date February 1, 20X3 March 1, 20X3 April 1, 20X3 July 1, 20X3 August 1, 20X3 October 1, 20X3 December 1, 20X3 Customer Yolanda's Yo Yos Wyman's Why Nots Pink's Panthers Lawrence's Ladders Mike's Minions Nick's Nicknacks Tom's Tanks Amount 70,700 31,000 58,900 75,600 71,500 77,700 82,500 467,900 Common Stock 10,100 Additional Paid-in 91,400 Cash receipts journal Date Description January 1, 20X3 Stock market February 1, 20X3 Paul's Go Karts February 1, 20X3 Greg's Garage March 1, 20X3 Yolanda's YoYos March 1, 20X3 Paul's Go Karts April 1, 20X3 Wyman's Why Nots April 1, 20X3 Yolanda's YoYos April 1, 20X3 Paul's Go Karts May 1, 20X3 Pink's Panthers May 1, 20X3 Yolanda's YoYos May 1, 20X3 Wyman's Why Nots June 1, 20X3 | Pink's Panthers June 1, 20X3 Wyman's Why Nots July 1, 20X3 Pink's Panthers August 1, 20X3 Lawrence's Ladders September 1, 20X3 Mike's Minions September 1, 20X3 Lawrence's Ladders October 1, 20X3 Mike's Minions October 1, 20X3 Lawrence's Ladders November 1, 20X3 Mike's Minions November 1, 20X3 Nick's Nicknacks December 1, 20X3 Nick's Nicknacks Accounts Collections Receivable 101,500 24,640 24,640 20,230 20.230 28,280 28,280 15,400 15,400 12,400 12,400 17,675 17,675 21,560 21,560 23,560 23,560 24,745 24,745 7,750 7,750 14,725 | 14,725 10,850 10,850 20.615 20,615 30,240 30,240 28,600 28,600 18,900 18,900 17,875 17,875 26,460 26,460 25,025 25,025 31,080 31,080 19,425 19,425 541,535 440,035 10,100 91,400 10,100 Number of $1 par value shares issued Cash disbursements Office Supplies On Hand Gasoline Marketing Utilities Car Payment Rent Prepaid Insurance Other 338 1.760 4.400 2,648 2.024 17.749 2.275 ATTITUIT 9,600 Accounts Amount Pavable 7,4707 ,470 7,470 7,470 4.400 338 1,760 4.400 27640 14,1 10 14,110 2,112 2. 112 2.024 192390 19,390 17.7491 2.275 338 9,600 21,000 27,720 1.498 4,400 338 1,6514 4.400 12.992 5,150 338 24.160 2.130 4.400 3238 1 207 4.400 41032 21.165 21 185 23,000 21,000 1,498 4.400 338 1,614 4.400 12.992 5.150 1 338 24.160 2,130 4,400 Check Date Vendor 193 January 1, 20X3 Scott's Most Excellent Lumber 194 January 1, 20X3 The Computer Shop 195 January 1, 20X3 Ricks Rentals 196 January 31, 20X3 Ferdinand's Fords 197 February 1, 20X3 Gary's Gas 198 February 1, 20X3 Rick's Rentals 199 February 1, 20X3 Homer's Office Supply 200 February 1, 20x3 Scott's Most Excellent Lumber 201 February 1. 20x3 Massive Building Supply Store 202 February 1, 20X3 Gary's Gas 203 February 1, 20X3 Ken's Tool Supply Company 204 February 1. 20X 3 TIRS 205 February 1, 20X3 Shareholders 206 February 28, 20X3 F erdinand's Fords 207 March 1, 20x3 Raj's Marketing 208 March 1, 20X3 Charles Schwab-short-term investr 209 March 1, 20X3 Big Insurance Company 210 March 1, 20x3 Gary's Gas 211 March 1. 20x3 Rick's Rentals 212 March 31, 20X3 Ferdinand's Fords 213 April 1, 20X3 Gary's Gas 214 April 1, 20X3 Ricks Rentals 215 April 1, 20X3 Brea Power and Light 216 April 1, 20X3 Shareholders 217 April 30, 20X3 Ferdinand's Fords 218 May 1, 20X3 You Crash 'Em Insurance Company 219 May 1, 20X3 Gary's Gas 220 May 1, 20X3 Rick's Rentals 221 May 31, 20X3 Ferdinand's Fords 222 June 1, 20X3 Gary's Gas 223 June 1. 20X3 Ricks Rentals 224 June 1. 20X3 Pink Pages (advertising) 225 June 1. 20X3 Scott's Most Excellent Lumber 226 June 1. 20X3 IRS 227 June 30, 20X3 Ferdinand's Fords 228 July 1, 20X3 Gary's Gas 229 July 1, 20X3 Rick's Rentals 230 July 1, 20x3 Brea Power and Light 231 July 31, 20X3 Ferdinand's Fords 232 August 1, 20X3 Garys Gas 233 August 1, 20X3 Rick's Rentals 234 August 1, 20X3 Massive Building Supply Store 235 August 31. 20X3 F erdinand's Fords 236 September 1, 20X3 Gary's Gas 237 September 1, 20x3 Rick's Rentals 238 September 1, 20x3 Scott's Most Excellent Lumber 239 September 30, 20X3 Ferdinand's Fords 240 October 1, 20X3 Massive Building Supply Store 241 October 1, 20X3 Shareholders 242 October 1, 20X3 Brea Power and Light 243 October 1, 20X3 Gary's Gas 244 October 1. 20X3 Ricks Rentals 245 October 31, 20x3 Ferdinand's Fords 246 November 1, 20X 3 Homer's Office Supply 247 November 1, 20X3 Gary's Gas 248 November 1, 20X3 Rick's Rentals 249 November 1, 20X3 Brea Home and Garden 250 November 30, 20X3Ferdinand's Fords 251 December 1, 20X3 Gary's Gas 252 December 1, 20X3 Rick's Rentals 253 December 31. 20X3 Ferdinand's Fords 338 1,207 4.032 THU FRI SATELLITE MI FILIALLEFT 23.000 338 338 1, 353T 4.400 6.992 338 1,044 4,400 2,640 III 1,8481 4,400 28,220 338 1,353 4.400 6.992 338 1.0441 4.400 2,640 3381 1,848 4,400 28,220 338 528 5,150 11,600 1,536 44001 338 3,654 2.0771 4,400 1.725 338 1.637 4.400 528 5.150 L 11,600 1.536 4,400 338 3,654 2,077 BA 1.725 4,400 1 4,400 ITTIIN 1,637 338 338 359,134 103, 105 19,728 15,357 31,584 52,800 2,056 6,300 51,880 14,3241 The payment to the Big Insurance company is a business insurance policy covering 12 months ended April 30, 20X4 The payment to the You Crash "Em Insurance company is an automobile insurance policy covering 16 months ended June 30, 20X4 The truck has a ten year useful life and $5,000 of salvage value Short-term investment Taxes payable Dividends payable 21,000 40,749 12,575 annos Adjustments 820 Ending balance of shop supplies on hand 890 Ending balance of office supplies on hand 12,700 Ending balance of lumber on hand Record depreciation expense (the company uses straight line for books and double declining balance for taxes) 5) $ 0.20 Dividend per share declared on December 31, 20X3 17,300 Unrealized gain on long-term investment 2,100 Unrealized gain on short-term investment Long-Term Short-Term Cost 57,750 21,000 Your statement of cash flows must use the Unrealized gain in 20X2 14,400 indirect method of disclosing operating cash Unrealized gain in 20X3 17,300 2,100 flows. Additionally, you must report the Ending fair value 89,450 23.100 direct method of disclosing operating cash 8) Adjust prepaid insurance and insurance expense flows as a separate disclosure. Do this for all 9) Write-off receivable from Sue's Paint Shop 10) Adjust allowance for doubtful accounts to the following percentage three years. 1.00% Estimated uncollectible accounts receivable 11) 36.00% Tax rate Show comprehensive income as a separate statement. Accounts receivable subsidiary reconciliation Sue's Paint Shop 28,380 Freeda's Fashions Carlos' Cars Peter's Planes Bob's Bank Earl's Earrings Greg's Garage 20,230 Paul's Go Karts 61,600 Total 110,210 Accounts payable subsidiary reconciliation Massive Building Supply Store Scott's Most Excellent Lumber The Computer Shop Ken's Tool Supply Company Total 7,470 7,470 Note: You must correct any errors in the second assignment (20X2) before you start working on this assignmnet. Business is good. To meet the delivery demands, Kline bought another truck. Not wanting to pay cash for the truck, though, she took advantage of the low interest rates offered by the Ford Dealership. Details on the purchase are shown below. General journal entry $ 10,300 Dividend declared by the Board of Directors during the year Market 5.60% Purchase of truck Coupon Purchase price 19,800 1.00% The term of the note is five years The note is due in monthly payments of principal and interest The truck has a ten year life and $5,000 of salvage value The payments on the note are made monthly. Convert the term of five years into monthly payments by multiplying it by 12, for a total of 60 payments. Divide the coupon interest rate by 12 to arrive at the monthly rate. Do not round the interest rate: Divide it by 12 and press the 1/YR button to input the result. Lumber Inventory Shop Supplies on Hand Tools Other 7,470 19,390 Detail below 14,1101 Purchases Journal Date January 1, 20X3 January 1, 20X3 January 1, 20X3 January 1, 20X3 May 1, 20X3 July 1, 20X3 August 1, 20X3 September 1, 20X3 December 1, 20X3 2,112 Vendor The Computer Shop Ken's Tool Supply Company Scott's Most Excellent Lumber Massive Building Supply Store Scott's Most Excellent Lumber Massive Building Supply Store Scott's Most Excellent Lumber Massive Building Supply Store Scott's Most Excellent Lumber Total 7,470 19,390 14,110 2,112 21,165 2,640 28,220 528 7,055 102,690 21,165 2,640 28,220 528 7,055 70,550 5,280 19,390 7,470 Table saw Lathe Cost 11,550 7,840 19,390 7,470 Useful Life Salvage 1,200 10800 Computer Sales Journal Date February 1, 20X3 March 1, 20X3 April 1, 20X3 July 1, 20X3 August 1, 20X3 October 1, 20X3 December 1, 20X3 Customer Yolanda's Yo Yos Wyman's Why Nots Pink's Panthers Lawrence's Ladders Mike's Minions Nick's Nicknacks Tom's Tanks Amount 70,700 31,000 58,900 75,600 71,500 77,700 82,500 467,900 Common Stock 10,100 Additional Paid-in 91,400 Cash receipts journal Date Description January 1, 20X3 Stock market February 1, 20X3 Paul's Go Karts February 1, 20X3 Greg's Garage March 1, 20X3 Yolanda's YoYos March 1, 20X3 Paul's Go Karts April 1, 20X3 Wyman's Why Nots April 1, 20X3 Yolanda's YoYos April 1, 20X3 Paul's Go Karts May 1, 20X3 Pink's Panthers May 1, 20X3 Yolanda's YoYos May 1, 20X3 Wyman's Why Nots June 1, 20X3 | Pink's Panthers June 1, 20X3 Wyman's Why Nots July 1, 20X3 Pink's Panthers August 1, 20X3 Lawrence's Ladders September 1, 20X3 Mike's Minions September 1, 20X3 Lawrence's Ladders October 1, 20X3 Mike's Minions October 1, 20X3 Lawrence's Ladders November 1, 20X3 Mike's Minions November 1, 20X3 Nick's Nicknacks December 1, 20X3 Nick's Nicknacks Accounts Collections Receivable 101,500 24,640 24,640 20,230 20.230 28,280 28,280 15,400 15,400 12,400 12,400 17,675 17,675 21,560 21,560 23,560 23,560 24,745 24,745 7,750 7,750 14,725 | 14,725 10,850 10,850 20.615 20,615 30,240 30,240 28,600 28,600 18,900 18,900 17,875 17,875 26,460 26,460 25,025 25,025 31,080 31,080 19,425 19,425 541,535 440,035 10,100 91,400 10,100 Number of $1 par value shares issued Cash disbursements Office Supplies On Hand Gasoline Marketing Utilities Car Payment Rent Prepaid Insurance Other 338 1.760 4.400 2,648 2.024 17.749 2.275 ATTITUIT 9,600 Accounts Amount Pavable 7,4707 ,470 7,470 7,470 4.400 338 1,760 4.400 27640 14,1 10 14,110 2,112 2. 112 2.024 192390 19,390 17.7491 2.275 338 9,600 21,000 27,720 1.498 4,400 338 1,6514 4.400 12.992 5,150 338 24.160 2.130 4.400 3238 1 207 4.400 41032 21.165 21 185 23,000 21,000 1,498 4.400 338 1,614 4.400 12.992 5.150 1 338 24.160 2,130 4,400 Check Date Vendor 193 January 1, 20X3 Scott's Most Excellent Lumber 194 January 1, 20X3 The Computer Shop 195 January 1, 20X3 Ricks Rentals 196 January 31, 20X3 Ferdinand's Fords 197 February 1, 20X3 Gary's Gas 198 February 1, 20X3 Rick's Rentals 199 February 1, 20X3 Homer's Office Supply 200 February 1, 20x3 Scott's Most Excellent Lumber 201 February 1. 20x3 Massive Building Supply Store 202 February 1, 20X3 Gary's Gas 203 February 1, 20X3 Ken's Tool Supply Company 204 February 1. 20X 3 TIRS 205 February 1, 20X3 Shareholders 206 February 28, 20X3 F erdinand's Fords 207 March 1, 20x3 Raj's Marketing 208 March 1, 20X3 Charles Schwab-short-term investr 209 March 1, 20X3 Big Insurance Company 210 March 1, 20x3 Gary's Gas 211 March 1. 20x3 Rick's Rentals 212 March 31, 20X3 Ferdinand's Fords 213 April 1, 20X3 Gary's Gas 214 April 1, 20X3 Ricks Rentals 215 April 1, 20X3 Brea Power and Light 216 April 1, 20X3 Shareholders 217 April 30, 20X3 Ferdinand's Fords 218 May 1, 20X3 You Crash 'Em Insurance Company 219 May 1, 20X3 Gary's Gas 220 May 1, 20X3 Rick's Rentals 221 May 31, 20X3 Ferdinand's Fords 222 June 1, 20X3 Gary's Gas 223 June 1. 20X3 Ricks Rentals 224 June 1. 20X3 Pink Pages (advertising) 225 June 1. 20X3 Scott's Most Excellent Lumber 226 June 1. 20X3 IRS 227 June 30, 20X3 Ferdinand's Fords 228 July 1, 20X3 Gary's Gas 229 July 1, 20X3 Rick's Rentals 230 July 1, 20x3 Brea Power and Light 231 July 31, 20X3 Ferdinand's Fords 232 August 1, 20X3 Garys Gas 233 August 1, 20X3 Rick's Rentals 234 August 1, 20X3 Massive Building Supply Store 235 August 31. 20X3 F erdinand's Fords 236 September 1, 20X3 Gary's Gas 237 September 1, 20x3 Rick's Rentals 238 September 1, 20x3 Scott's Most Excellent Lumber 239 September 30, 20X3 Ferdinand's Fords 240 October 1, 20X3 Massive Building Supply Store 241 October 1, 20X3 Shareholders 242 October 1, 20X3 Brea Power and Light 243 October 1, 20X3 Gary's Gas 244 October 1. 20X3 Ricks Rentals 245 October 31, 20x3 Ferdinand's Fords 246 November 1, 20X 3 Homer's Office Supply 247 November 1, 20X3 Gary's Gas 248 November 1, 20X3 Rick's Rentals 249 November 1, 20X3 Brea Home and Garden 250 November 30, 20X3Ferdinand's Fords 251 December 1, 20X3 Gary's Gas 252 December 1, 20X3 Rick's Rentals 253 December 31. 20X3 Ferdinand's Fords 338 1,207 4.032 THU FRI SATELLITE MI FILIALLEFT 23.000 338 338 1, 353T 4.400 6.992 338 1,044 4,400 2,640 III 1,8481 4,400 28,220 338 1,353 4.400 6.992 338 1.0441 4.400 2,640 3381 1,848 4,400 28,220 338 528 5,150 11,600 1,536 44001 338 3,654 2.0771 4,400 1.725 338 1.637 4.400 528 5.150 L 11,600 1.536 4,400 338 3,654 2,077 BA 1.725 4,400 1 4,400 ITTIIN 1,637 338 338 359,134 103, 105 19,728 15,357 31,584 52,800 2,056 6,300 51,880 14,3241 The payment to the Big Insurance company is a business insurance policy covering 12 months ended April 30, 20X4 The payment to the You Crash "Em Insurance company is an automobile insurance policy covering 16 months ended June 30, 20X4 The truck has a ten year useful life and $5,000 of salvage value Short-term investment Taxes payable Dividends payable 21,000 40,749 12,575 annos Adjustments 820 Ending balance of shop supplies on hand 890 Ending balance of office supplies on hand 12,700 Ending balance of lumber on hand Record depreciation expense (the company uses straight line for books and double declining balance for taxes) 5) $ 0.20 Dividend per share declared on December 31, 20X3 17,300 Unrealized gain on long-term investment 2,100 Unrealized gain on short-term investment Long-Term Short-Term Cost 57,750 21,000 Your statement of cash flows must use the Unrealized gain in 20X2 14,400 indirect method of disclosing operating cash Unrealized gain in 20X3 17,300 2,100 flows. Additionally, you must report the Ending fair value 89,450 23.100 direct method of disclosing operating cash 8) Adjust prepaid insurance and insurance expense flows as a separate disclosure. Do this for all 9) Write-off receivable from Sue's Paint Shop 10) Adjust allowance for doubtful accounts to the following percentage three years. 1.00% Estimated uncollectible accounts receivable 11) 36.00% Tax rate Show comprehensive income as a separate statement
