Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi please see attached 3 files and do it according to instructions in rubric thanks Unit 10 [209: Small Business Management] AssignmenttRubric Financial
Hi please see attached 3 files and do it according to instructions in " rubric " thanks
Unit 10 [209: Small Business Management] Assignment\tRubric Financial Control of your Business \"C\" is the final letter of the POLC functions of management Control. Financial control is an important means of controlling overall short term and long term success of a business. In your final Assignment concerning financial statements, you will interpret a statement based on given assumptions provided. You will need to use two files located in Doc Sharing. Checklist: 1. Download two files from Doc Sharing: a) Unit 10 Assignment Spreadsheet (Excel file) b) Unit 10 Assignment Assumptions (Word doc) 2. Then estimate a P&L statement based on the assumptions. 3. Answer the questions: Does the firm need to borrow money at the end of the year to meet expenses? Why or why not? 4. Submit your answer to the questions and your estimated P&L spreadsheet to the Dropbox before the end of this unit. Grading Rubric Unit 10 Assignment Content per Checklists Percent possible 100% Points possible 50 Response provides correct and complete information demonstrating analysis and critical thinking: Submits a correctly estimated the P&L statement based on the assumptions provided in the template. The data in the template substantiates his/her responses to the questions. Subtotal: 20 40 Points Earned Comments Unit 10 [209: Small Business Management] Writing, spelling, grammar, and APA/Submits the completed template for the unit Assignment. Your Assignment Score: 20% 10 50 Scenario A assumptions Unit 10 Assume monthly sales are $280,000 October, $290,000 November, and $345,000 December Assume Inventory purchases are $60,000 Oct, $60,000 Nov, and $70,000 Dec Assume the owner gets a cash disbursement in Oct of 45,000, Nov of 51,000, and Dec of 52,000 Assume wages and salaries are 48% of gross monthly sales Assume rent is $9500 a month Assume utilities are 5% of gross monthly sales Assume a tax prepayment of $16,000 in October Assume bank interest on the note is $15000/month Assume a depreciation expense of $15,000 in December October Gross revenue Inventory Purch (c Net Sales Cash Disbursement Wages & Salaries Rental Exp Utilities Tax Prepayment Interest on Bank N Depreciation Total Expenses Profit November 0 0 0 0 0 0 0 0 0 0 0 0 December 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0Step 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