Please could you help me to fill-up the excel below and could you let me know which formula do you use for each input. Also, could you let me know the conclusion?
Guidance
Balance sheet
She noted that "Product development" expense consists primarily of salary to employees. She noted that there were about 10 employees who work in this department and all are paid about the same salary in 20x7. Note there was 1 new employees hired in January 20x8. Each employee received a salary increase of about 20%. No other significant changes were noted in this department. Inflation was steady during the period. Using a reasonableness analytic estimate Produce development expense for 20x8. * See the "Q5-7 Guidence" tab for additional instructions Expected Value (Rounded to thousand) Value per 2018 FS (Rounded to thousand) Difference Conclusion Account Name PY Value(s) (Rounded to thousand) (Rounded to thousand) Salary Expense $830,000 $ 1,014 $ (1,014) For "Expected Value" and "Difference" Use actual excel formulas in the following cells to complete your calculation.-> HINTS: | 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
