60.1K

Verified Solution

Link Copied!

please help me fill out the balance sheet with Excel with information provided.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline A. A & B. & C & D & E & F & G & H & 1 & J \\ \hline 227 & & \multicolumn{2}{|c|}{ d. capital expenditures. } & & & 8 & & & \\ \hline 228 & & & & & & & & & \\ \hline 229 & & & & & & & & & \\ \hline 230 & & \multicolumn{6}{|c|}{ 9. Bennie Razor Company has decided to sell one of its old manufacturing machines } & & \\ \hline 231 & & \multicolumn{6}{|c|}{ on June 30,2012 . The machine was purchased for $80,000 on lanuary 1,2008 , and } & & \\ \hline 232 & & \multicolumn{6}{|c|}{ was depreciated on a straight-line basis for 10 years assuming no salvage value. } & & \\ \hline 233 & & \multicolumn{6}{|c|}{ If the machine was sold for $26,000, what was the amount of the gain or loss } & & \\ \hline 234 & & \multicolumn{3}{|c|}{ recorded at the time of the sale? } & & & & & \\ \hline 235 & & i & & & 8 & as & & & \\ \hline 236 & & \begin{tabular}{l} Machine \\ purchased \end{tabular} & 80,000 & & 1/1/2008 & & & & \\ \hline 237 & & & & & & & & & \\ \hline 238 & & \begin{tabular}{l} Machine \\ Sold \end{tabular} & 26,000 & 8: & 6/30/2012 & & & & \\ \hline 239 & & & & & & & & & \\ \hline 240 & & Yearshold & 4.5 & 4.5 & & & & & Chart Area \\ \hline 241 & & & & & & & & & \\ \hline 242 & & \begin{tabular}{l} No Salvage \\ Value \end{tabular} & 10 & & & & & & \\ \hline 243 & & & & & & & & & \\ \hline 244 & & \begin{tabular}{l} amount of \\ the gain or \\ loss \end{tabular} & 18,000 & & & & & & \\ \hline 245 & & & & & & & & & \\ \hline 246 & & a. $18,000. & & c. $22,000. & & & & & \\ \hline 247 & & b. $54,000. & & d. $46,000. & & & & & \\ \hline 248 & & & & & & & & & \\ \hline 249 & & Equipment ( & (machine) Data & & & & & & \\ \hline 250 & & & & & & & & & \\ \hline 251 & & Cost $80,000 & & & & 80,000 & & & \\ \hline 252 & & Expected sal & Ivage value $0,000 & & & = & & & \\ \hline 253 & & Estimated us & seful Life in years 10 & & & 10 & & & \\ \hline 254 & & Estimated us & seful tife in miles & & & 8,000 & & & \\ \hline 255 & & 4 & & & & & & & \\ \hline 256 & & Depreciable & Cost & & & 80,000 & & & \\ \hline 257 & & Annual Depr & reciable Expense & & & 8,000 & & & \\ \hline 258 & & Annual Rate & of Depreciation & & & 10.0% & & & \\ \hline 259 & & & & & & & & & \\ \hline 260 & & & Book Value equals C & ost minus Accur & nulated Depre & eciation & & & \\ \hline \end{tabular} depreciation line at June 2012 : Wright records the Sale and the Gain on Disposal of the Plant Asset as follows. Wright records the Sale and the Gain on Disposal of the Plant Asset as follows. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline A. A & B. & C & D & E & F & G & H & 1 & J \\ \hline 227 & & \multicolumn{2}{|c|}{ d. capital expenditures. } & & & 8 & & & \\ \hline 228 & & & & & & & & & \\ \hline 229 & & & & & & & & & \\ \hline 230 & & \multicolumn{6}{|c|}{ 9. Bennie Razor Company has decided to sell one of its old manufacturing machines } & & \\ \hline 231 & & \multicolumn{6}{|c|}{ on June 30,2012 . The machine was purchased for $80,000 on lanuary 1,2008 , and } & & \\ \hline 232 & & \multicolumn{6}{|c|}{ was depreciated on a straight-line basis for 10 years assuming no salvage value. } & & \\ \hline 233 & & \multicolumn{6}{|c|}{ If the machine was sold for $26,000, what was the amount of the gain or loss } & & \\ \hline 234 & & \multicolumn{3}{|c|}{ recorded at the time of the sale? } & & & & & \\ \hline 235 & & i & & & 8 & as & & & \\ \hline 236 & & \begin{tabular}{l} Machine \\ purchased \end{tabular} & 80,000 & & 1/1/2008 & & & & \\ \hline 237 & & & & & & & & & \\ \hline 238 & & \begin{tabular}{l} Machine \\ Sold \end{tabular} & 26,000 & 8: & 6/30/2012 & & & & \\ \hline 239 & & & & & & & & & \\ \hline 240 & & Yearshold & 4.5 & 4.5 & & & & & Chart Area \\ \hline 241 & & & & & & & & & \\ \hline 242 & & \begin{tabular}{l} No Salvage \\ Value \end{tabular} & 10 & & & & & & \\ \hline 243 & & & & & & & & & \\ \hline 244 & & \begin{tabular}{l} amount of \\ the gain or \\ loss \end{tabular} & 18,000 & & & & & & \\ \hline 245 & & & & & & & & & \\ \hline 246 & & a. $18,000. & & c. $22,000. & & & & & \\ \hline 247 & & b. $54,000. & & d. $46,000. & & & & & \\ \hline 248 & & & & & & & & & \\ \hline 249 & & Equipment ( & (machine) Data & & & & & & \\ \hline 250 & & & & & & & & & \\ \hline 251 & & Cost $80,000 & & & & 80,000 & & & \\ \hline 252 & & Expected sal & Ivage value $0,000 & & & = & & & \\ \hline 253 & & Estimated us & seful Life in years 10 & & & 10 & & & \\ \hline 254 & & Estimated us & seful tife in miles & & & 8,000 & & & \\ \hline 255 & & 4 & & & & & & & \\ \hline 256 & & Depreciable & Cost & & & 80,000 & & & \\ \hline 257 & & Annual Depr & reciable Expense & & & 8,000 & & & \\ \hline 258 & & Annual Rate & of Depreciation & & & 10.0% & & & \\ \hline 259 & & & & & & & & & \\ \hline 260 & & & Book Value equals C & ost minus Accur & nulated Depre & eciation & & & \\ \hline \end{tabular} depreciation line at June 2012 : Wright records the Sale and the Gain on Disposal of the Plant Asset as follows. Wright records the Sale and the Gain on Disposal of the Plant Asset as follows

Answer & Explanation Solved by verified expert

See Answer