can you please help me out

also can please use the XL templet below

AutoSave ON n F8 9069 ... BSBSMB421_AE_Sk_3of5_TDC - Last Modified: Wed at 9:14 am Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 22 A" A Aa Ap AaBbCcDdEe AaBbCCDdEe AaBbC AaBb AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe Paste BI Uvab X X A LA Body Body footer Cover subtitle Cover title feature Footer - Doc.. Guide text Styles Dictate Pane Part 1: Produce financial reports To complete this part of the assessment, you will be required to use the given financial information and produce several financial reports. Once completed you will need to submit this assessment for marking. Scenario Michael has decided to buy a 40-unit motel for $1 280 000, which begins operations in January next year. This amount includes land valuation at $100 000, building at $990 000, furniture & equipment at $180 000 and a cash at bank balance of $10 000. This was all paid from a business loan from the bank. The loan will be paid over 10 years at 8.9% pa, although he has agreed to pay $12 000 per month interest and $8 000 per month for the principal repayments for this for simplistic purposes. The building has an estimated life of 30 years and the furniture and equipment for 10 years. Use straight-line depreciation for the building and furniture & equipment. For the first 3 months of operations, occupancy is forecast to be 65%, 70%, and 75% respectively. The average room rate will be $75. In calculating room sales revenue, assume this year is not a leap year. All sales will be on a cash basis. Michael and his partner will manage the motel themselves, with monthly wages of $2 500 each. The following cash expenses are estimated: . Employee wages expense (including super) will be $15 000 a month. . Laundry and supplies are 12% of monthly sales revenue. . Insurance premiums are $25 000 for the first year. . Advertising is budgeted to be $2 000 per month. Energy costs to be $2 200, $2 400 and $2 500 respectively for each of the first 3 months. The monthly energy cost for month 1 will be paid in month 2; month 2 in month 3, and so on. Administrative, office and other expenses will be $1 500 monthly. Page 6 of 27 4581 words [ English (Australia) Focus E + 105%AutoSave ON n F8 9069 ... BSBSMB421_AE_Sk_3of5_TDC - Last Modified: Wed at 9:14 am Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 22 AaBbCcDdEe AaBbCcDdEe AaBbC AaBb AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe Paste BIUvab X X A LA DV V Body Body footer Cover subtitle Cover title feature Footer - Doc.. Guide text Styles Dictate Pane Use the template Financial Reports Template.xIsx to prepare the following financial reports or each of the first three (3) months of the motel operation, rounding figures to the nearest dollar: 1. A Cash Flow Projection 2. An Income Statement 3. A Balance Sheet as at 31 March Questions 1. Interpret and analyse the data from the financial reports you have produced: Your answers should be between 100 and 200 words for each and should be written in sentence form. a. Income Statement b. Balance Sheet Page 7 of 27 4581 words [ English (Australia) Focus E + 105%Excel File Edit View Insert Format Tools Data Window Help 50% ~ Q 8 Sat 16 Oct 11:15 am AutoSave OFF n H ? O ... Financial reports templates Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 AA =1 Wrap Text General Ex AP- O. Analyse Paste BIUV E E Merge & Centre $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles Filter Select Data H4 X V fx A B C D E F G H I J K L M N 0 P Q R S T U Actual Income Analysis for January Favourable/ Rassoning or suggested strategies 3 Budget Actual Variance Unfavourable for improvement Room sales revenue Operating expenses 10 11 12 13 16 18 20 26 28 29 30 31 32 33 34 35 36 37 D Cash Budget template Income Statement template Balance Sheet template Actual Income analysis + + 100% Ready 169 OCT 16