Base on the attachment blow please prepare worksheet in excel. Also, show all the formulas.

Forensic Accounting Case Buzzy's Drive - In Date of Loss: July 30, 2013 This case is a restaurant that had a fire and was out of business from the date of loss through January 31, 2014. You are to calculate the loss on a monthly basis and to total the loss for all of the months on a separate worksheet to get to the total loss. Show your schedules for each month just like it was discussed in class. You have been provided the historical sales, financial statements and income tax returns. You are to use this data in performing the loss calculation. Partial credit will be given if you don't compute the loss correctly etc. The owner owns the building the drive-in was located in and he was paid his monthly rent during the loss period. You are to review the expenses and determine what you feel would have been continued to be paid along with the rent. You will use these same monthly amounts each month of the calculation. Re: Buzzy's Drive~In Date of Loss: July 30, 2013 Historical & Projected Monthly Sales As Summarized & Calculated Month January February March April May June July August September October November December Total 2010 See Note 1 2011 See Note 1 2012 See Note 1 $18,712 18,712 18,712 18,712 18,712 18,712 18,712 18,712 18,712 18,712 18,712 18,712 $17,398 17,398 17,398 17,398 17,398 17,398 17,398 17,398 17,398 17,398 17,398 17,398 $17,255 17,255 17,255 17,255 17,255 17,255 17,255 17,255 17,255 17,255 17,255 17,255 $224,542 $208,777 $207,057 2013 2014 Comment $0 $16,080 20,255 18,745 19,239 16,403 16,619 0 0 0 $107,341 Preliminary and for discussion purposes only. $0 Profit or Loss From Business SCHEDULEC (Fonn OMB No. 15450074 (Sole Proprietorship) 1040) 2012 "For information on Schedule C and Its Instructions, go to www.irs.gov/scheduJec. "Attach to Fonn 1040, lO4ONR, or 1041i partnerships generally must file Fonn 1065. Name of proprietor A E Sequence No. 09 Social security number (SSN) B PrinCipal busmess or profeSSIon, including product or service (see instructions) Restaurant C Attachment Enter code from i~struction. .. 722513 D Business name. It no sepMate busir . s name. leave blank. Employer ID number (EIN), (see instrs) I Business address (including suite or room no.) .. City. town or post office, state. and ZIP cooe 0 F Accounting method: (1) ~ Cash (2) Accrual (3) Other (specify) .. G Did you 'materially participate' in the operation of this business during 2012? If 'No,' see instructions for limit on losses. H If you started or acquired this business during 2012, check here.. ....... . .......... . [E! Yes .. 0 I Did you make any payments in 2012 that would require you to file Form(s) 10997 (see instructions) .. agYes J If 'Yes: did you or will you file all required Forms 1099? ............................... . 2 DYes Gross receipts or sales. See instructions for line 1 and check the box if this income was reported to you on Form W2 and the 'Statutory employee' box on that form was checked. . . . . . . . . . . . . . . . . . . . . . . . .. . .. Returns and allowances (see instructions). . . . . . .. . .. .. . . . . . ........ . 0 I---t---.....!=-.!..L~~=- 3 4 5 6 Advertising. 9 Car and truck expenses (see instructions) . 10 Commissions and fees. 11 Contract labor (see instructions) ...... . 12 Depletion. 13 Depreciation and section 179 expense deduction (not included in Part III) (see instructions) .... 14 Employee benefit programs (other than on line 19. . ... Pension and profitsharing plans ..... Rent or lease (see instructions): a Vehicles, machinery, and equipment. b Other business property .. 21 Repairs and maintenance. ~:'-f---------i 22 Supplies (not included in Part III) .. Taxes and licenses.................... . Travel, meals, and entertainment: a Travel.. b Deductible meals and entertainment (see instructions) .. 15 Insurance (other than health) .. 25 Utilities.... 16 Interest: a Mortgage (paid to banks, etc).. 1--''-:'-1f---------i 26 Wages (less employment credits) . bOther. 1--'---11----------1 27 a Other expenses (from line 48) ional services.. b for use ... 17 28 Total expenses before expenses for business use of home. Add lines 8 through 27a .. 29 Tentative profit or (loss), Subtract line 28 from line 7... " ......... . 30 Expenses tor business use of your home. Attach Fonn 8829. Do not report such expenses elsewhere .. 31 Net profit or (loss). Subtract line 30 from line 29. 32 If a profit, enter on both Form 1040, line 12 (or Fonn 1040NR, line 13) and on } Schedule SE, line 2. If you checked the box on line 1, see instructions). Estates and trusts, enter on Fonn 1041, line 3. If a loss, you must go to line 32. If you have a loss, check the box that describes your investment in this activity (see instructions). If you checked 32a, enter the loss on both Fonn 1040, line 12, (or Fonn 1040NR, line 13) and on Schedule SE.line 2.