Could you help me to fill-up the below excel only for the yellow box and please let me know which formula did I should use. Also the conclusion. Thank you.
Guidance to answer the question.
Balance sheet
REVENUE/SALES- Based on economic conditions, she believes that the increase in sales for the current year should approximate the historical trend. (Industry sales have been increasing by double digits for the last five years, competitor sales increases have ranged from 10-30% increases year over year for the last 5 years.) Using a reasonableness analytic estimate expected revenue for 20X8 using the historical data provided.
All information should be taken from below to calculate expected revenue for 20X8
Lourend REVENUE/SALES-Based on economic conditions, she believes that the increase in sales for the current year should approximate the historical trend. (Industry sales have been increasing by double digits for the last five years, competitor sales increases have ranges from 10-30% increases year over year for the last 5 years.) Using a reasonableness analytic estimate expected revenue for 20X8 using the historical data provided. USE the TABLE PROVIDED BELOW TO PERFORM THIS CALCULATION See the "Q5-7 Guidence" tab for additional instructions Actual Value per Expected Value 20x8 FS Account PY Value(s) (Rounded (Rounded to thousand) Rounded to Difference $& % Conclusion Name to thousand) (Sho, the difference as a $ amount and a percentagel 4,000 ($4,000.00) Average Percentage increase See below [2014-2015=% 2015-2016=% Revenue 2016-2017=%] #DIV/0! Average of 3 year change=% Average increase (20X7 Revenue* Average 3yr Change %) = $ For "Expected Value" and "Difference" Use actual excel formulas in the following cells to Year 20X8 2017 20x6 20x5 20x4 Revenue % Change Account Name PY Value(s) (Rounded to thousand) Expected Value (Rounded to thousand) Value per 2018 FS (Rounded to thousand) Conclusion (Rounded to thousand) The difference of $10K is less than TM of $375K. Deemed Reasonable. $485 $10 Write out the data/ Accounts [(450*10%) + formula you plan to $450 Receivable 450]= $495 use.-> Use actual excel formulas in the following cells to complete your 4951 calculation.-> 485 101 December 31, 20X8 and 20X7 (in thousands) 20X8 20X7 Assets Current assets Cash and cash equivalents $3,741 $3,019 Accounts receivables 1,119 900 Inventory 100 150 Total current assets 4,960 4,069 741 711) Property Plan & Equipment (PP&E), net Goodwill Investments Other assets Total assets Liabilities and shareholders' equity Current liabilities Notes payable Accounts payable 90,000 634 175 $96,480 0 633 105 $5,548 $140 $130 $181 $1,089 20001 0 2.320 1,219 Long Term Debt Total liabilities Shareholders' equity Common stock Retained earnings Total shareholders' equity Total liabilities plus shareholders' equity 91,131 3.029 94.160 $96,480 2,329 2.000 4,329 $5,548 Average Percentage increase [2014-2015=% 2015-2016=% 2016-2017=%] Average of 3 year change=% Average increase (20X7 Revenue* Average 3yr Change %=$1 Lourend REVENUE/SALES-Based on economic conditions, she believes that the increase in sales for the current year should approximate the historical trend. (Industry sales have been increasing by double digits for the last five years, competitor sales increases have ranges from 10-30% increases year over year for the last 5 years.) Using a reasonableness analytic estimate expected revenue for 20X8 using the historical data provided. USE the TABLE PROVIDED BELOW TO PERFORM THIS CALCULATION See the "Q5-7 Guidence" tab for additional instructions Actual Value per Expected Value 20x8 FS Account PY Value(s) (Rounded (Rounded to thousand) Rounded to Difference $& % Conclusion Name to thousand) (Sho, the difference as a $ amount and a percentagel 4,000 ($4,000.00) Average Percentage increase See below [2014-2015=% 2015-2016=% Revenue 2016-2017=%] #DIV/0! Average of 3 year change=% Average increase (20X7 Revenue* Average 3yr Change %) = $ For "Expected Value" and "Difference" Use actual excel formulas in the following cells to Year 20X8 2017 20x6 20x5 20x4 Revenue % Change Account Name PY Value(s) (Rounded to thousand) Expected Value (Rounded to thousand) Value per 2018 FS (Rounded to thousand) Conclusion (Rounded to thousand) The difference of $10K is less than TM of $375K. Deemed Reasonable. $485 $10 Write out the data/ Accounts [(450*10%) + formula you plan to $450 Receivable 450]= $495 use.-> Use actual excel formulas in the following cells to complete your 4951 calculation.-> 485 101 December 31, 20X8 and 20X7 (in thousands) 20X8 20X7 Assets Current assets Cash and cash equivalents $3,741 $3,019 Accounts receivables 1,119 900 Inventory 100 150 Total current assets 4,960 4,069 741 711) Property Plan & Equipment (PP&E), net Goodwill Investments Other assets Total assets Liabilities and shareholders' equity Current liabilities Notes payable Accounts payable 90,000 634 175 $96,480 0 633 105 $5,548 $140 $130 $181 $1,089 20001 0 2.320 1,219 Long Term Debt Total liabilities Shareholders' equity Common stock Retained earnings Total shareholders' equity Total liabilities plus shareholders' equity 91,131 3.029 94.160 $96,480 2,329 2.000 4,329 $5,548 Average Percentage increase [2014-2015=% 2015-2016=% 2016-2017=%] Average of 3 year change=% Average increase (20X7 Revenue* Average 3yr Change %=$1
