60.1K

Verified Solution

Link Copied!

Tableau Dashboard Activity 8-1: Depreciation Methods Vantyfe was founded by Marc Roberts, an entrepreneur, mountain biker, and all-around adventure junkie, Marc started Vantyfe to help others get into the lfestyle by renting out camper vans for cross country travel. To start the business, Marc raised $50,000 cash through the issuance of common stock to cover basic operating expenses, Marc olso took out a loan of $120,000 to purchase his first ven for rent. Marc estimates that the van will have a useful life of 10 years, can be diven up to 200,000 miles, and will have a $20,000 sovape value at the end of its life. Marc intends to charge customers based on the number of days they rent the van and the total minenge driven. Marc is trying to decide which depreciation method to use when accounting for the van, and has prepared the Tableau Dashboard below to assist him in his decision making. The visualization summarizes the occounting effects of three difforent methods of depreciationc double-declining, units of production (unit of measure is miles diven), and straight line. The three bar charts ot the top show the impact that each method will have on the balances sheet ever the useful life of the van. You can see these effects over time by using the "Year' slider at the top right corner of the visualization. The three line charts at the bottom show the balance in the accurnulated depreciation account over the life of the van. Note that oll other business events have been held constant over time to show only the impact of depreciation on the balance sheet over time. To assist Marc in his decision making, use the visualization to answer the following questions: Account Cash Notes Payable Common Stock Retained Earnings BV Rental Van Under which method of depreciation will the book value of the van at the end of its useful life be lowest? (Hint: Use the "Year" slider to compare the balances sheets across all three methods at the end of the van's useful life.) Complete this question by entering your answers in the tabs below. Which method of depreciation is depicted by Depreciation Method 2 in the visualization? Complete this question by entering your answers in the tabs below. Which method of deprecation makes the assumption that the van will wear down evenly over the course of its lifetime? Depreclation Method 3 represents the units of production method as shown by the inconsistent change in the book value of the van over its uscful life and the inconsistent trend in accumulated depreciation line chart. gased on the visualization, in which year did the rental van incur the most miles driven? Based on the nature of VanLyfe's business, which method of depreciation should Marc choose to best match the depreciation expense rocognized on the rental van to the revenues earned from the van

Answer & Explanation Solved by verified expert

See Answer