Formulas Please I need help big time ASAP! THANK YOU!

FUXED ASSET SUBSIDLARY LEDGER Item Purch From Est. Life Where Located Loading Dock Est salvage: This is the accounting system used for a small company. There are many journals listed that may no be used. On July 3, 2024 they purchased a printer/fax/copier for the office from Rande Supplies for \$250. The machine has no salvage value and a four-year life. Add a new ledger for the machine and calculate and record the 2024 deprecation expense for ALL fixed assets. The company uses straight-line depreciation. 6 Highlight rows that you adjust so that they are easily visible in yellow. USE FORMULAS!! \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A B & c & D & E & F & G & H & 1 & 1 & K & L & M \\ \hline & & \multicolumn{5}{|c|}{ CASH RECEIPTS JOURNAL DECEMBER } & & & & & \\ \hline \multirow[b]{3}{*}{ Date } & \multirow[b]{3}{*}{ Description } & \multicolumn{3}{|c|}{ DEBIT } & \multicolumn{7}{|c|}{ CREDIT } \\ \hline & & Cr. & Cash & Sales Disc. & & GL 10200 & & Salos & Othe & her G/2 & \\ \hline & & Init: & GR 10100 & GL 30300 & Subs ACH & Amt. & Post & G/L 30100 & AC# & Ant - & Post \\ \hline Dec. & 2 Flo's Department Store & PJ & 820000 & & & +4 & He & 8.200 .00 & & & \\ \hline Dec & 3 Mils Company & pu & 275.00 & & & & & & 31200 & 27500 & x \\ \hline Dec. & 9 ElectroWorld & PJ & 1470000 & 30000 & 516 & 1500000 & x & & & & \\ \hline Dec & 10 Wendsuar Elactronics. & PJ & 5.48800 & 112.00 & 518 & 5.600000 & x & & & & \\ \hline Doc: & 11: Hunson Company & PJ & 500000 & & & & & 5,000.00 & & & \\ \hline Doc & 13 Kompler Beauty SE Sopio & PJ & 9.67900 & & 521 & 9.67900 & x & & & D & \\ \hline & 13 Kozy Kactrene & PJ & 320000 & & & & & 3,20000 & & & \\ \hline 5.Dec & 23 Eectrowand & PJ & 3.40000 & & 51.6 & 3,40000 & x & & & =0 & \\ \hline 16Dec & 23 Wiendover Electronics & PJ & 1.763 .60 & 36.40 & 618 & 1,82000 & x & & & & \\ \hline 17Dec & 26 Fins Socuria Bank & Pd & 75,00000 & & & & & & 21000 & 75.000001 & x \\ \hline 18.19 & & & & & & & & & & & \\ \hline 20 & & = & & -1 & & & & & & & \\ \hline 21 & Woratis Totals & & 126,72560 & 448.40 & & 35,49900 & & & & & \\ \hline 22 & = & & & & & & & 16.400 .00 & & 75.27500 & \\ \hline 23. & & and & & & & -1 & & & & & \\ \hline 24 & & & & & & & & & & & -1 \\ \hline \end{tabular} TURNER DISTRIBUTING ISENFRAL JOURWLL \begin{tabular}{|c|c|c|} \hline 89 & & Groor \\ \hline 9091 & Credit & Balanco \\ \hline 92 & 27.23 & 27.23 \\ \hline 93 & & = \\ \hline 94 & 26.22 & 26.22 \\ \hline 95 & & = \\ \hline 96 & 49.47 & 49.47 \\ \hline 97 & & 49.47 \\ \hline 98 & & 49.47 \\ \hline 99 & & 49.47 \\ \hline 100 & & \\ \hline 101102 & Credit & CreditBalance \\ \hline 103 & & - \\ \hline 104 & 6.99 & 6.99 \\ \hline 105 & & \\ \hline 106 & 9.25 & 9.25 \\ \hline 107 & & \\ \hline 108 & 1466 & 1466 \\ \hline 109 & & 14.66 \\ \hline 110 & & 1466 \\ \hline 111 & & 14.66 \\ \hline 112 & & \\ \hline 113114 & Credit & CreditBalance \\ \hline 115 & & 97560 \\ \hline 116 & & \\ \hline 117 & 572.85 & 572.85 \\ \hline 118 & 572.85 & 1.145 .70 \\ \hline 119 & & \\ \hline 120 & 559.50 & 559.50 \\ \hline 121 & 559.50 & 1,11900 \\ \hline 122 & & \\ \hline 123 & 63691 & 636.91 \\ \hline 124 & 636.91 & 1273.82 \\ \hline 125 & - & 1.273 .82 \\ \hline 126 & & 1.27362 \\ \hline 128 & & \\ \hline 129 & Credin & Balance \\ \hline 130 & & \\ \hline 131 & 522202 & 5.22202 \\ \hline 132133 & & Credit \\ \hline 134 & Crean & Belance \\ \hline 136 & & \\ \hline 136137 & 123.29 & 12329 \\ \hline 138159 & & CreditRatarran \\ \hline \end{tabular} fx Dec. AB C \begin{tabular}{ll|l|l|l|l|l|l|l|l|l|l} D & E & F & G \end{tabular} H SALES JOURNAL DECEMBER 2 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & \multirow{2}{*}{\multicolumn{2}{|c|}{ Date }} & \multirow[b]{2}{*}{ Customer } & \multirow{2}{*}{InvoiceorCr.MemoNumber} & \multirow[b]{2}{*}{Subsid.Acct.No.} & \multirow[b]{2}{*}{Subsid.Post} & \multicolumn{2}{|c|}{ Debit } & Credit \\ \hline & & & & & & & Accout.Rec.G/L.10200 & \begin{tabular}{|r|} Sales Returns \\ G/L 30200 \\ \end{tabular} & SalesG/L31000 \\ \hline & Dec. & 4 & ElectroWorld & 836 & 516 & x & 15,000.00 & & 15,000.00 \\ \hline & Dec. & 5 & Wendover Electronics & 837 & 518 & X & 5,600.00 & & 5.600 .00 \\ \hline & Dec. & 11 & ElectroWorld & 838 & 516 & x & 7.580 .00 & & 7,580.00 \\ \hline & Dec. & 13 & Wendover Electronics & 839 & 518 & X & 1,820.00 & & 1,820.00 \\ \hline 10 & Dec. & 18 & Clean Images & 840 & 517 & x & 11,100.00 & & 11,100.00 \\ \hline 11 & & & & & & B & & - & \\ \hline 12 & & & & +2 & +1 & & & & \\ \hline 13 & & & Monthly Totals & +2 & +2 & & 41,100.00 & - & 41.100 .00 \\ \hline 14 & & & & +2 & & & x2 & & \\ \hline 15 & & & & & & & & & \\ \hline 16 & & & \begin{tabular}{|r} \\ \end{tabular} & & + & + & Z & & \\ \hline 17 & & & & & & & & & \\ \hline 18 & & & & +2 & & & & & \\ \hline 19 & & & \begin{tabular}{|l} \\ \end{tabular} & & & & +2 & & +2 \\ \hline 20 & E & & & +2 & +2 & & & & \\ \hline \end{tabular} 21 23 24. 25 26 28 29 30 3 \begin{tabular}{|c|c|c|c|c|c|} \hline Invoice or & & & De & bit & Credit \\ \hline Cr.MemoNumber & Subsid.Acct.No. & Subsid.Post & Accout.Rec.G/L10200 & SalesReturnsG/L30200 & Sale:G/L31000 \\ \hline 836 & 516 & x & 15,000.00 & & 15,000.00 \\ \hline 83 & 518 & X & 5,600.00 & & 5.600 .0 \\ \hline 838 & 516 & x & 7.580 .00 & & 7.580 .00 \\ \hline 839 & 518 & x & 1,820.00 & & 1,820.00 \\ \hline 840 & & x & 11,100,00 & & 11,100.00 \\ \hline & & & & & \\ \hline & & & & & \\ \hline+2 & & 20 & 41,100.00 &. & 41,100.00 \\ \hline+2 & +2 & & 1 & & 6 \\ \hline 4 & & & I & & \\ \hline & & & & & 4 \\ \hline & & & & & 4 \\ \hline & & & & & - \\ \hline+2 & & & & & \\ \hlinex2 & & - & & & \\ \hline \end{tabular} 817 - x