For tax and accounting purposes, businesses often have to depreciate equipment values over time. One method of depreciation is the straight$-$line method. Three years ago Hilde Construction purchased a bulldozer for $$51,500.$ Using the straight$-$line method, the bulldozer has now depreciated to a value of $$43,200.$ If V equals the value at the end of year t$,$ write a linear equation expressing the value of the bulldozer over time. How many years from the purchase date will the value equal $$0?$ Round your answer to two decimal places. Complete the following steps:Reply to this discussion prompt the method to find the linear equation V in terms of t$.$ Show all your work.Open an excel spreadsheet, label t in column C$10,$ label V$($t$)$ in column D$10.$At cell D$11,$ type the formula you found in step $1$ for V$($t$),$ use cell reference for the time t from column C$.$ Input a list of values for time t in column C$.$ What is a reasonable starting point for t$?$ Please discuss this in your discussion reply. Generate the value of V$($t$)$ based on the input value of t$.$ Graph the linear function V$($t$)$ using Insert $>$ Charts $>$ Scatter with Smooth Lines.From the results, make a guess of how many years from the purchase date will the value equal $$0.$ Discuss this in your discussion reply. Make sure to include the screenshot of the plot in your discussion reply.Use the $=$intercept$()$ function to calculate the exact value of the time t on your Excel file. Compare this exact value to your guess value of t in step $7.$ Discuss this in your reply. Please make sure to explain how you use the $=$intercept$()$ function on your data in your discussion reply.