Please create a SCF for quarter 3 - please show excel formulas as well.

Our report has to present the IS, BS and SCF all on one page, and all numbers are to be rounded up (no decimal points)

FSA - Assignment 1 The balance sheet of DCC Corp., as of the end of Quarter 2, is provided below BS Spring 19 Assets Liab. & Owners Equit Cash A/R Inventory $11,300 Accounts payable $1,000 $500 $8,000 $4,000 Long-term debt Common Stock ($2 par value) Paid-in-surplus Retained Earnings parts finished goods $600 $6,000 $5,000 $1,400 Total Assets $18,900Liab. & Owners Equity $18,900 During Quarter 3: DCC purchased $2500 worth of parts, $1500 with cash, the remainder to be paid in Quarter 4 Sold 6 computers, each for $725 4 were sold for cash, 2 were sold on credit with payment to be received in Quarter 4 The gross margin was 46% Annual interest rate on LTD is 2.3%. Interest is paid and expensed quarterly SG&A expenses$550 were paid in Quarter 3 The tax rate is 35% and Quarter 3 taxes will be paid in Quarter 4 The dividend payout ratio (dividends/Net Income) is 30% (paid immediately) 200 new shares of common stock were issued and sold for $2500 in Quarter 3 Purchase the warehouse DCC is located in for $20,000 cash on the first day of Quarter 3 $22,000 long-term debt was issued on the first day of the quarter The warehouse will be depreciated over 20 years. Depreciation is expensed quarterly FSA - Assignment 1 The balance sheet of DCC Corp., as of the end of Quarter 2, is provided below BS Spring 19 Assets Liab. & Owners Equit Cash A/R Inventory $11,300 Accounts payable $1,000 $500 $8,000 $4,000 Long-term debt Common Stock ($2 par value) Paid-in-surplus Retained Earnings parts finished goods $600 $6,000 $5,000 $1,400 Total Assets $18,900Liab. & Owners Equity $18,900 During Quarter 3: DCC purchased $2500 worth of parts, $1500 with cash, the remainder to be paid in Quarter 4 Sold 6 computers, each for $725 4 were sold for cash, 2 were sold on credit with payment to be received in Quarter 4 The gross margin was 46% Annual interest rate on LTD is 2.3%. Interest is paid and expensed quarterly SG&A expenses$550 were paid in Quarter 3 The tax rate is 35% and Quarter 3 taxes will be paid in Quarter 4 The dividend payout ratio (dividends/Net Income) is 30% (paid immediately) 200 new shares of common stock were issued and sold for $2500 in Quarter 3 Purchase the warehouse DCC is located in for $20,000 cash on the first day of Quarter 3 $22,000 long-term debt was issued on the first day of the quarter The warehouse will be depreciated over 20 years. Depreciation is expensed quarterly