How to calculate the financial statement for the City Tire? How I get all the blank in the spreadsheet? any formulas and recommended book?

Tire City, Inc. Name: Paola De Marco Financial Statements For Years Ending 12/31 1993 1994 1995 1996 1997 INCOME STATEMENT Net sales 16,230 20,355 23,505 28,206 33,847 0.350 Cost of sales Gross Profit SG&A expenses Depreciation 9,430 6,800 5,195 160 11,898 8,457 6,352 180 13,612 9,893 7,471 213 16,416 11,790 - 19,699 14,148 - 0.350 0.300 1.000 0.333333 Net interest expense Pre-tax income 119 1,326 106 1,819 94 2,115 11,790 14,148 546 780 822 997 925 1,190 11,790 14,148 155 200 240 2,358 2,830 20% 20% 20% Income taxes Net income Dividends Dividend rate BALANCE SHEET Assets Cash A/R 20% 20% 508 2,545 609 3,095 706 3,652 - - Inventories Total current assets 1,630 4,683 1,838 5,542 2,190 6,548 - - Gross PP&E 3,232 3,795 4,163 - - Accumulated depreciation Net PP&E 1,335 1,897 1,515 2,280 1,728 2,435 - - 6,580 7,822 8,983 - - Liabilities & shareholders' equity Current maturities of long-tem debt A/P 125 1,042 ### 1,325 125 1,440 - - Accrued expenses Total current liabilities 1,145 2,312 1,432 2,882 1,653 3,218 - - Long-term debt Total liabilities 1,000 3,312 875 3,757 750 3,968 - - Common stock 1,135 ### 1,135 - - Retained earnings Total shareholders' equity 2,133 3,268 2,930 4,065 3,880 5,015 - - 6,580 7,822 8,983 - - Total assets Total liabilities & shareholders' equi