Balance Sheet and Income Statement in Excel

Shown below is an adjusted trial balance for Sprouts Farmers Market, Inc. for the period ending December 31, 2016 (with the exception of Accumulated Deficit, which shows the balance at December 31, 2015):

(*) 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, 2017 and the second installment on August 1, 2018. Management intends to hold onto the companys investments until December 2018 at which point the investments will be sold. The company paid out $10,000 in dividends to its shareholders in 2016. 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, 2016. Prepaid advertising is for newspaper marketing services that will be provided over the first eight-months of 2017. The company had 97,000 common shares outstanding on January 1, 2016. It issued an additional 46,000 common shares on July 1, 2016. Sprouts has a 43.91% income tax rate Sprouts incurred aggregate losses since its inception, which resulted in an Accumulated Deficit at the end of 2015.