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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!