Part $1$: prepare an income Statement and Balance Sheet

Financial accounting based

Must be in Excel$\backslash$table$[[$Accounts payable,,$283,500],[$Accounts receivable,$631,155,],[$Accumulated depreciation,,$393,750],[$Advertising expense,$56,700,],[$Allowance for doubtful accounts,,$55,598],[$Bad debt expense,$36,750,],[$Capital gains,,$12,600],[$Capital stock $($common$),,945,000],[$Cash$,355,005,],[$Charitable contributions,$26,250,],[$Compensation expense,$1,396,500,],[$Cost of goods sold,$848,400,],[$Depreciation expense,$21,000,],[$Dividends $($paid$),85,050,],[$Dividends $($received$),,16,800],[$Entertainment expense,$3,675,],[$Equipment$,1,470,000,],[$Federal income tax expense,$263,340,],[$Gain from disposition of fixed assets,,$4,148],[$Interest expense,$65,100,],[$Interest income,,$15,750]]$