50.1K

Verified Solution

Link Copied!

Using the results from your 2018 income statement, calculate the effect a change in the Dealer and Tax percentage may have on profit. Create a two-way data table that tests the effect on profit when the dealer percentage is 10%, 11%, 12%, 13%, 14%, 15%, 16%, 17%, 18%, 19% and 20%, and the tax percentage is 25%, 30%, 35%, 40%, 45%, and 50%. See Example 11.21 Show a screenshot of your Two-Way Data Table.

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline Proforma Income Statement & & & & & & One Way Data Table & \\ \hline & & & & & & & Profit \\ \hline & 2014 & 2015 & 2016 & 2017 & 2018 & Dealer & \\ \hline Sales & $84,532,250.00 & $103,883,750.00 & $126,203,400.00 & $156,410,100.00 & $196,445,370.00 & 0.1 & \\ \hline Cost of Goods Sold & $42,965,817.00 & $52,723,795.00 & $64,516,024.00 & $77,515,149.00 & $104,128,001.00 & 0.11 & \\ \hline & & & & & & 0.13 & \\ \hline Operating Expenses & & & & & & 0.14 & \\ \hline Dealer Percentage & 18% & 18% & 18% & 18% & 18% & 0.15 & \\ \hline Administrative Expenses & $7,413,206.00 & 7,952,839.00 & 8,917,696.00 & 7,964,649.00 & 7,738,943.00 & 0.16 & \\ \hline Depreciation Expenses & $1,869,274.00 & $2,026,001.00 & $2,483,744.00 & $2,251,791.00 & $2,486,977.00 & 0.18 & \\ \hline Total & $24,498,285.00 & $28,677,915.00 & $34,118,052.00 & $38,370,258.00 & $45,586,086.60 & 0.19 & \\ \hline & & & & & & 0.2 & \\ \hline Net Operating Income & $17,068,148.00 & $22,482,040.00 & $27,569,324.00 & $40,524,693.00 & $46,731,282.40 & & \\ \hline Interest Expense & 93,468.00 & 92,589.00 & 110,277.00 & 121,465.00 & 117,855.00 & & \\ \hline Earnings Before Taxes & $16,974,680.00 & $22,389,451.00 & $27,459,047.00 & $40,403,228.00 & $46,613,427.40 & & \\ \hline Tax Percentage & 50% & 50% & 50% & 50% & 50% & & \\ \hline Taxes (Earning before taxes * Tax \%) & $8,487,340.00 & $11,194,725.50 & $13,729,523.50 & $20,201,614.00 & $23,306,713.70 & & \\ \hline Net Income & $8,487,340.00 & \$ 11,194,725.50 & $13,729,523.50 & $20,201,614.00 & $23,306,713.70 & & \\ \hline & & & & & & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer