a$.$ Input: Enter all values on this tab including your name, title of the financial statements, and financial accounts and numbers

b$.$ IS: Prepare an income statement using only formulas and cell references from the input tab

c$.$ RE: Prepare a retained earnings statement using only formulas and cell references from the input tab

d$.$ BAL: Prepare a balance sheet using only formulas and cell references from the input tab.$\backslash$table$[[,$A$,$B$,$C$,$D$,E,$F$,$G$],[1,,,$Lamp Light Company$],[2,,,$End$-$of$-$Period Spreadsheet$],[3,*,,$For the Year Ended December $31,2016],[4,,$Unadjusted Trial Balance,Adjustments,Adjusted Trial Balance$],[5,],[6,$Account Title,Dr$.,$Cr$.,$Dr$.,$Cr$.,$Dr$.,$Cr$.],[7,,,,,,,],[8,$Cash,$10,800,,,,10,800,],[9,$Accounts Receivable,$38,900,,,,50,200,],[10,$Prepaid Insurance,$4,200,,($a$)11,300,($b$)3,000,1,200,],[11,$Supplies,$2,730,,,($c$)2,250,480,],[12,$Land,$98,000,,,,98,000,],[13,$Building,$400,000,,,,400,000,],[14,$Accum. Depr.$-$Building,,$205,300,,($d$)10,100,,215,400],[15,$Equipment,$101,000,,,,101,000,],[16,$Accum. Depr.$-$Equipment,,$85,100,,($e$)6,680,,91,780],[17,$Accounts Payable,,$15,700,,,,15,700],[18,$Salaries a$.$ Input: Enter all values on this tab including your name, title of the financial statements, and financial accounts and numbers

b$.$ IS: Prepare an income statement using only formulas and cell references from the input tab

c$.$ RE: Prepare a retained earnings statement using only formulas and cell references from the input tab

d$.$ BAL: Prepare a balance sheet using only formulas and cell references from the input tab.$\backslash$table$[[,$A$,$B$,$C$,$D$,E,$F$,$G$],[1,,,$Lamp Light Company$],[2,,,$End$-$of$-$Period Spreadsheet$],[3,*,,$For the Year Ended December $31,2016],[4,,$Unadjusted Trial Balance,Adjustments,Adjusted Trial Balance$],[5,],[6,$Account Title,Dr$.,$Cr$.,$Dr$.,$Cr$.,$Dr$.,$Cr$.],[7,,,,,,,],[8,$Cash,$10,800,,,,10,800,],[9,$Accounts Receivable,$38,900,,,,50,200,],[10,$Prepaid Insurance,$4,200,,($a$)11,300,($b$)3,000,1,200,],[11,$Supplies,$2,730,,,($c$)2,250,480,],[12,$Land,$98,000,,,,98,000,],[13,$Building,$400,000,,,,400,000,],[14,$Accum. Depr.$-$Building,,$205,300,,($d$)10,100,,215,400],[15,$Equipment,$101,000,,,,101,000,],[16,$Accum. Depr.$-$Equipment,,$85,100,,($e$)6,680,,91,780],[17,$Accounts Payable,,$15,700,,,,15,700],[18,$Salaries