70.2K

Verified Solution

Link Copied!

Balance sheet and income statement in Excel ? please

balance sheet and income statement, by draft no Excel sheet please

Please,Solve for balance sheet and income statement

Shown below is an adjusted trial balance for Sprouts Farmers Market, Inc. for the period ending December 31, 2017 (with the exception of Accumulated Deficit, which shows the balance at December 31, 2016): ACCOUNT COGS Loss on sale of equipment RALANCE 51.264.514 99 ACCOUNT Investments (*) Note Receivable (0) Selling gen a dministrativ expenses BALANCE 9.521 45.156 19 Accumulated Deficit (*) Accumulated Depreciation Inventory Interest income Property and equipment (gross) Goodwill Sales Revenue Accounts Receivable (gross) Additional paid-in-capital Accumulated other comprehensive incom Taiterest Expense Loans from Bank 20,351 94,034 98,382 562 393,200 408,078 1.794.823 9,015 435.480 2,000 Accounts Payable Prepaid Advertising Intangible Assets (net) Common stock Amortization of trademarks Cash and cash equivalents Allowance for doubtful accounts 82.721 6.535 196,772 126 4,937 67 211 600 Direet store expenses Accrued salaries 35.488 584.802 363,32 48,958 (*) Additional information: The note receivable is structured such that Sprouts will receive the balance in two equal annual equal installments with the first payment to be received on August 1, 2018 and the second installment on August 1, 2019. Management intends to hold onto the company's investments until December 2019 at which point the investments will be sold The company paid out $10,000 in dividends to its shareholders in 2017. Almost all of the loans from the banks are due in 3 years or more with the exception of a 90-day line of credit that has a balance of $5,167 on December 31, 2017 Prepaid advertising is for newspaper marketing services that will be provided over the first eight-months of 2018 The company had 97,000 common shares outstanding on January 1, 2017. It issued an additional 46,000 common shares on July 1, 2017 Sprouts bas a 43.91% income tax rate Sprouts incurred aggregate losses since its inception, which resulted in an Accumulated Deficit at the end of 2016. Shown below is an adjusted trial balance for Sprouts Farmers Market, Inc. for the period ending December 31, 2017 (with the exception of Accumulated Deficit, which shows the balance at December 31, 2016): ACCOUNT COGS Loss on sale of equipment RALANCE 51.264.514 99 ACCOUNT Investments (*) Note Receivable (0) Selling gen a dministrativ expenses BALANCE 9.521 45.156 19 Accumulated Deficit (*) Accumulated Depreciation Inventory Interest income Property and equipment (gross) Goodwill Sales Revenue Accounts Receivable (gross) Additional paid-in-capital Accumulated other comprehensive incom Taiterest Expense Loans from Bank 20,351 94,034 98,382 562 393,200 408,078 1.794.823 9,015 435.480 2,000 Accounts Payable Prepaid Advertising Intangible Assets (net) Common stock Amortization of trademarks Cash and cash equivalents Allowance for doubtful accounts 82.721 6.535 196,772 126 4,937 67 211 600 Direet store expenses Accrued salaries 35.488 584.802 363,32 48,958 (*) Additional information: The note receivable is structured such that Sprouts will receive the balance in two equal annual equal installments with the first payment to be received on August 1, 2018 and the second installment on August 1, 2019. Management intends to hold onto the company's investments until December 2019 at which point the investments will be sold The company paid out $10,000 in dividends to its shareholders in 2017. Almost all of the loans from the banks are due in 3 years or more with the exception of a 90-day line of credit that has a balance of $5,167 on December 31, 2017 Prepaid advertising is for newspaper marketing services that will be provided over the first eight-months of 2018 The company had 97,000 common shares outstanding on January 1, 2017. It issued an additional 46,000 common shares on July 1, 2017 Sprouts bas a 43.91% income tax rate Sprouts incurred aggregate losses since its inception, which resulted in an Accumulated Deficit at the end of 2016

Answer & Explanation Solved by verified expert

See Answer