Problem 17 please finish Required: Prepare the balance sheet according to the USALI.

Problem 17The trial balance of balance sheet accounts of Lancer's a popular casual dining spot asDecember 31 20* 3 , is as follows :DebitsCashCredits$ 5090Marketable SecuritiesAccounts Receivable10 090Allowance for Doubtful Accounts20 090Food Inventory5 0 05 0Prepaid RentPrepaid Insurance50 0nInvestments8 000Land0 000Building80 900Equipment20 090Accumulated Depreciation10. 090Accounts PayableIncome Taxes Payable100 000Accrued Expenses15 090Dividends Payabi25, 00Balance Sheet 235Long Term DebtCapital Stock304 0Paid - In Capital in Excess of Par89 090Retained Earnings ( 1 /1 x 3 )GX DDD61090Additional informintion :1 . Dividends declared during 20*3 totaled $30 010 . On$20 000 of the dividendsdeclared in 20*3 have been paid as of December 31 20* 3 . The unpaid dividends havenot been recordedOperations generated $809 090 of revenue for$650 090 . Additional adjustments required are as follows :20*3 . Expenses recorded totaledThe allowance for doubtful accounts should be adjusted to 10 percent of accountsreceivableb . Prepaid insurance of $8 , 100 is the premium paid for insurance coverage for July 120*3 through June 30 20 *4Unrecorded depreciation expense for 20 * 3 totals $41 090d . Income taxes have not been recorded . Lancer's average rate is 20 percent3 . The Long -Term Debt account includes $50 ,100 that must be paid on June 30 , 20 *4RequiredPrepare a balance sheet according to the LISALL