Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 LiabilitiesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started