Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help :( Lab 1-2 Excel Part 2: Assessment Questions Answer the following questions based the details provided. begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline & A & B &

please help :(
image text in transcribed
image text in transcribed
image text in transcribed
Lab 1-2 Excel Part 2: Assessment Questions Answer the following questions based the details provided. \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & 1 Current Year & 2025 & & & & & & \\ \hline 2 & & & & Original & & & & \\ \hline 3 & 3 Year Placed in Service & Useful ufe & Description & Cost & Salvage Value & SLN & DDB & SYD \\ \hline 4 & 12022 & 5 & Shovel & 50 & 10 & $8.00 & $7.20 & $8.00 \\ \hline 5 & 52024 & 5 & Garden fork & 50 & 10 & $8.00 & $20.00 & $13.33 \\ \hline 6 & 2022 & 5 & Rake & 50 & 10 & $8.00 & $7.20 & $8.00 \\ \hline 7 & 72022 & 5 & Dutch hoe & 50 & 10 & $8.00 & $7.20 & $8.00 \\ \hline 8 & 2023 & 5 & Garden fork & 50 & 10 & $8.00 & $12.00 & $10.67 \\ \hline 9 & 2021 & 7 & Lawn Shears & 20 & 5 & $2.14 & $2.08 & $2.14 \\ \hline 10 & 02019 & 7 & Pruners & 80 & 10 & $10.00 & $4.25 & $5.00 \\ \hline 11 & 12022 & 5 & Trowel & 20 & 5 & $3.00 & $2.20 & $3.00 \\ \hline 12 & 2023 & 5 & Chain Saw & 650 & 50 & $120.00 & $156.00 & $160.00 \\ \hline 13 & 2022 & 5 & Power Trimmer & 650 & 50 & $120.00 & $93.60 & $120.00 \\ \hline 14 & 42020 & 10 & Trailer for Equipment & 2,000 & 200 & $180.00 & $163.84 & $196.36 \\ \hline 15 & 52023 & 5 & Push Lawnmower 1 & 1,100 & 150 & $190.00 & $264.00 & $253.33 \\ \hline 16 & 62022 & 7 & Dump Trailer & 15,000 & +3,500 & $1,642.86 & $2,186.59 & $2,053.57 \\ \hline 17 & 2022 & 5 & Truck 1 & 35,000 & 3,000 & $6,400.00 & $5,040.00 & $6,400.00 \\ \hline 18 & 32024 & 5 & Truck 2 & 35,000 & 3,000 & $6,400.00 & $14,000.00 & $10,666.67 \\ \hline 19 & 2023 & 5 & Riding Lawnmover & 4,500 & 500 & $800.00 & $1,080.00 & $1,066.67 \\ \hline 20 & 2023 & 5 & Push Lawnmower 2 & 500 & 100 & $80.00 & $120.00 & $106.67 \\ \hline 21 & & & & & & $15,988.00 & $23,166.16 & $21,081.41 \\ \hline 22 & & & & & & & & \\ \hline 33 & & & & & & & & \\ \hline 24 & & & & & & & & \\ \hline 25 & & & & & & & & \\ \hline2726 & & & \pm & & . & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 1 & Current Year & 2026 & & & & & & \\ \hline 2 & & & & Original & & & & \\ \hline 3 & Year Placed in Service & Useful Life. & Description & Cost & Salvage Value & SLN & DDB & SYD \\ \hline 4 & 2022 & 5 & Shovel & 50 & 10 & $8.00 & $0.80 & $5.33 \\ \hline 5 & 202.4 & 5 & Garden fork & 50 . & 10 & $8.00 & $12.00 & $10.67 \\ \hline 6 & 2022 & 5 & Rake & 50 & 10 & $8.00 & $0.80 & $5.33 \\ \hline 7 & 2022 & 5 & Dutch hoe & 50 & 10 & $8.00 & $0.80 & $5.33 \\ \hline 8 & 2023 & 5 & Garden fork & 50 & 10 & $8.00 & $7.20 & $8.00 \\ \hline 9 & 2021 & 7 & Lawn Shears & 20 & 5 & $2.14 & $0.21 & $1.61 \\ \hline 10 & 2019 & 7 & Pruners & 80 & 10 & $10.00 & $0.62 & $2.50 \\ \hline 11 & 2022 & 5 & Trowel & 20 & 5 & $3.00 & $0.00 & $2.00 \\ \hline 12 & 2023 & 5 & Chain Saw & 650 & 50 & $120.00 & $93.60 & $120.00 \\ \hline 13 & 2022 & 5 & Power Trimmer & 650 & 50 & $120.00 & $56.16 & $80.00 \\ \hline 14 & 2020 & 10 & Trailer for Equipment & 2,000 & 200 & $180.00 & $131.07 & $163.64 \\ \hline 15 & 2023 & 5 & Push Lawnmower 1 & 1,100 & 150 & $190.00 & $158.40 & $190.00 \\ \hline 16 & 2022 & 7 & Dump Trailer & 15,000 & 3,500 & $1,642.86 & $1,561.85 & $1,642.86 \\ \hline 17 & 2022 & 5 & Truck 1 & 35,000 & 3,000 & $6,400.00 & $3,024.00 & $4,266.67 \\ \hline 18 & 2024 & 5 & Truck 2 & 35,000 & 3,000 & $6,400.00 & $8,400.00 & $8,533.33 \\ \hline 19 & 2023 & 5 & Riding Lawnmover & 4,500 & 500 & $800.00 & $648.00 & $800.00 \\ \hline 20 & 2023 & 5 & Push Lawnmower 2 & 500 & 100 & $80.00 & $72.00 & $80.00 \\ \hline 21 & & & & & & $15,988.00 & $14,167.51 & $15,917.27 \\ \hline 22 & & & & & & & & 2 \\ \hline 23 & &. & & & & & & \\ \hline 24 & & & & & & & & \\ \hline 25 & & & & & . & & & \\ \hline \end{tabular}

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

Guide To Financial Audit In Life And Health Insurance

Authors: Naser-Eddine Nebbache

1st Edition

6205873397, 978-6205873397

More Books

Students also viewed these Accounting questions

Question

In Problems 6584, solve each equation. 1 25

Answered: 1 week ago