Please fill in the highlighted cells (YOU MUST USE EXCEL FORMULAS FOR CREDIT) 12/31/19 Assets Liabilities...

 

Transcribed Image Text:

Please fill in the highlighted cells (YOU MUST USE EXCEL FORMULAS FOR CREDIT) 12/31/19 Assets Liabilities Equity 12/31/20 Assets Liabilities Equity During 2020 Total revenues Total expenses Net Income Clinic A $2,500.00 $4,200.00 Clinic A $575.00 $12,250.00 Clinic A $3,200.00 Clinic B $32,000.00 $19,000.00 Clinic C Clinic B $15,000.00 $5,500.00 $32,500.00 Clinic B Clinic C $19,750.00 $125,000.00 $4,200.00 $54,000.00 Clinic C $25,000.00 Clinic D $75,325.00 $52,750.00 Clinic D $2,500.00 $88,500.00 Clinic D $62,500.00 Please fill in the highlighted cells (YOU MUST USE EXCEL FORMULAS FOR CREDIT) 12/31/19 Assets Liabilities Equity 12/31/20 Assets Liabilities Equity During 2020 Total revenues Total expenses Net Income Clinic A $2,500.00 $4,200.00 Clinic A $575.00 $12,250.00 Clinic A $3,200.00 Clinic B $32,000.00 $19,000.00 Clinic C Clinic B $15,000.00 $5,500.00 $32,500.00 Clinic B Clinic C $19,750.00 $125,000.00 $4,200.00 $54,000.00 Clinic C $25,000.00 Clinic D $75,325.00 $52,750.00 Clinic D $2,500.00 $88,500.00 Clinic D $62,500.00

Answer rating: 100% (QA)

To calculate the highlighted cells using Excel formulas 1 Equity as o... View the full answer