Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help me out when writing your answer please use the financial report template that I have provided you thank you AutoSave ON
Can you please help me out
when writing your answer please use the financial report template that I have provided you thank you
AutoSave ON T HS 9069 ... w- BSBSMB421_AE_Sk_3of5_TDC - Last Modified: Just now Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 22 EVEN EVENT AaBbCcDdEe AaBbCCDdEe AaBbC AaBb AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe Paste BIUvab 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: Page 6 of 27 4583 words English (Australia) Focus + 186%AutoSave ON T HS 9069 ... w- BSBSMB421_AE_Sk_3of5_TDC - Last Modified: Just now 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 BIUvab X X A LA Body Body footer Cover subtitle Cover title feature Footer - Doc.. Guide text Styles Dictate Pane 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. Document title: BSBSMB421_AE_Sk_3of5_TDC Page 6 of 27 Resource ID: TBS_18_017_BSBSMB421_AE_Sk_3of5_TDC STUDENT NAME: Page 6 of 27 4583 words X English (Australia) Focus + 186%AutoSave ON T HS w- BSBSMB421_AE_Sk_3of5_TDC - Last Modified: Just now Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 22 A A Aav A EVENEEVEE AaBbCcDdEe AaBbCcDdEe AaBbC AaBb AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe Paste BI Uvab X X A DAY Body Body footer Cover subtitle Cover title feature Footer - Doc.. Guide text Styles Dictate Pane Document title: BSBSMB421_AE_Sk_3of5_TDC Page 6 of 27 Resource ID: TBS_18_017_BSBSMB421_AE_Sk_3of5_TDC STUDENT NAME: NSW GOVERNMENT TAFE Use the template Financial Reports Template.xlsx to prepare the following financial reports for 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 Page 6 of 27 4583 words English (Australia) Focus E + 186%AutoSave OFF C ... 3. Financial reports templates Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 AA al Wrap Text v General Paste BIUV vAv E = Merge & Centre v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyse Formatting as Table Styles Filter Select Data B4 4 fx A B C D E F G H J K L M N 0 P Q R S U Actual Income Analysis for January NI Favourable/ Rassoning or suggested strategies 3 Budget Actual Variance Unfavourable for improvement Room sales revenue Operating expenses 6 00 11 13 16 35 36 37 38 39 40 41 42 D Income Statement template Balance Sheet template Actual Income analysis + Ready + 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started