Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Hi please see attached 3 files and do it according to instructions in " rubric " thanks

image text in transcribed 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 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jeff Madura, Hardeep Singh Gill

4th Canadian edition

134724712, 134724713, 9780134779782 , 978-0134724713

More Books

Students also viewed these Finance questions

Question

Do I really need this item?

Answered: 1 week ago