Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Debra C. Jeter, Paul Chaney

5th Edition

978-1118098615

Students also viewed these Accounting questions