Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please help me fill out the balance sheet with Excel with information provided.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Business Management From Planning To Performance

Authors: Gary Cokins

1st Edition

1937352358, 978-1937352356

More Books

Students also viewed these Accounting questions