Accounting Managerial

Hello! My professor asked me to prepare a budget and a prodit and loss FORECAST of an imaginary business, he said it did not have to be complex. Here attached is the tempate he sent is to help us so the assignment.

XYZ Company Profit and Loss Statement Forecast For the Year ending December 31, 2019 This section is optional - can be used to make calculations (i.e. total costs times total memberships in the case of a Gym) Date: Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 XXX XXX XXX XXX XXX XXX Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Total Feb-21 110,000 Revenue Jan-21 Membership Rev 100,000 Personal Training Rev XXX XXX Total Revenue 100,000 110,000 Expenses Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Total XXX Depreciation for Gym Equipment XXX 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 V 45,000 XXX XXX XXX XXX XXX XXX XXX Total Expenses 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 45,000 Operating Income/(Loss) 95,000 95% 105,000 (5,000) 95% #DIV/0! (5,000) #DIV/0! (5,000) #DIV/0! (5,000) #DIV/0! (5,000)_(5,000) (5,000) (45,000) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0