Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please correct vlookup formula begin{tabular}{|c|c|c|c|c|} hline & fx= VLOOK & multicolumn{2}{|c|}{= VLOOKUP(A31,$A$16:$D$23,4,FALSE) } hline & A. & B & C & D hline

please correct vlookup formula

image text in transcribed \begin{tabular}{|c|c|c|c|c|} \hline & fx= VLOOK & \multicolumn{2}{|c|}{= VLOOKUP(A31,\$A\$16:\$D\$23,4,FALSE) } \\ \hline & A. & B & C & D \\ \hline 20 & 5 & & 11.52% & 8.93% \\ \hline 21 & 6 & & 5.76% & 8.92% \\ \hline 22 & 7 & & & 8.93% \\ \hline 23 & 8 & & & 4.46% \\ \hline \multicolumn{5}{|l|}{24} \\ \hline 25 & Asset: & \multicolumn{2}{|c|}{ Industrial Refrigeration Equipment } & \\ \hline 26 & Class Life: & & 70 & \\ \hline 27 & Basis: & $1,434,214 & & \\ \hline \multicolumn{5}{|c|}{28} \\ \hline 29 & \multicolumn{3}{|c|}{ Depreciaiton } & \\ \hline 30 & Year & Rate & Amount & \\ \hline 31 & & 14.29% & $204,949.18 & \\ \hline 32 & & 24.49% & $351,239.01 & \\ \hline 33 & & 17.49% & $250,844.03 & \\ \hline 34 & & 12.49% & $179,133.33 & \\ \hline 35 & & 8.93% & $128,075.31 & \\ \hline 36 & & 8.92% & $127,931.89 & \\ \hline 37 & & 8.93% & $128,075.31 & \\ \hline 38 & & 4.46% & $63,965.94 & \\ \hline 39 & & Total & $1,434,214.00 & \\ \hline 40 & & & & \\ \hline 41 & & Fully Depreciated? & Yes & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & fx= VLOOK & \multicolumn{2}{|c|}{= VLOOKUP(A31,\$A\$16:\$D\$23,4,FALSE) } \\ \hline & A. & B & C & D \\ \hline 20 & 5 & & 11.52% & 8.93% \\ \hline 21 & 6 & & 5.76% & 8.92% \\ \hline 22 & 7 & & & 8.93% \\ \hline 23 & 8 & & & 4.46% \\ \hline \multicolumn{5}{|l|}{24} \\ \hline 25 & Asset: & \multicolumn{2}{|c|}{ Industrial Refrigeration Equipment } & \\ \hline 26 & Class Life: & & 70 & \\ \hline 27 & Basis: & $1,434,214 & & \\ \hline \multicolumn{5}{|c|}{28} \\ \hline 29 & \multicolumn{3}{|c|}{ Depreciaiton } & \\ \hline 30 & Year & Rate & Amount & \\ \hline 31 & & 14.29% & $204,949.18 & \\ \hline 32 & & 24.49% & $351,239.01 & \\ \hline 33 & & 17.49% & $250,844.03 & \\ \hline 34 & & 12.49% & $179,133.33 & \\ \hline 35 & & 8.93% & $128,075.31 & \\ \hline 36 & & 8.92% & $127,931.89 & \\ \hline 37 & & 8.93% & $128,075.31 & \\ \hline 38 & & 4.46% & $63,965.94 & \\ \hline 39 & & Total & $1,434,214.00 & \\ \hline 40 & & & & \\ \hline 41 & & Fully Depreciated? & Yes & \\ \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

Financial Accounting International Edition

Authors: Jeffrey Waybright, Robert Kemp

1st Edition

0137067798, 978-0137067794

More Books

Students also viewed these Accounting questions

Question

=+a) Is this an experimental or observational study? Explain.

Answered: 1 week ago