Question: Please show work on spreadsheets, I really need to see the formula on spreadsheets Balance sheet: Taraet Corp (TGT at NYSE) Assets Inventory Accounts receivable


Please show work on spreadsheets, I really need to see the formula on spreadsheets
Balance sheet: Taraet Corp (TGT at NYSE) Assets Inventory Accounts receivable Cash Other current assets Total current assets 2019 $4,760 $5,565 $758 $852 $11,935 Land, plant, property, and equipment At cost Accumulated depreciation Net land, plant, property and equipment $20,936 $5,629 $15,307 Other assets Total assets $1,361 $28,603 $10,186 $1,451 Liabilities and shareholder equity Long term debt Deferred income taxes Shareholders equity Common stock Accumulated retained earnings Total equity $1,332 $8,111 $9,443 Total liabilities and shareholder equity Accounts payable Accrued liabilities Income taxes payable Current portion of LT debt & notes payable Total current liabilities $28,603 $4,684 $1,545 $319 $975 $7,523 1) Create Excel formula to calculate Current Ratio. (0.5 mark) Total Current Assets Current Ratio = Total Current Liabilities 2) Create Excel formula to calculate Debt to Equity. (0.5 mark) Long term debt Debt to Equity Total equity = 3) Create Excel formula to calculate Quick Ratio. (0.5 mark) Accounts receivable + Cash + Inventory Quick Ratio = Total Current Liabilities
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
