{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T06:45:21-04:00", "answer_date": "2024-06-28 06:45:21", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4254964", "url": "\/study-help\/questions\/please-see-attached-auto-graded-spreadsheet-you-must-not-change-4254964", "question_creation_date_js": "2024-06-28T06:45:21-04:00", "question_creation_date": "Jun 28, 2024 06:45 AM", "meta_title": "[Solved] Please see attached auto graded spreadshe | SolutionInn", "meta_description": "Answer of - Please see attached auto graded spreadsheet, you MUST not change any of the macros in any of the tabs. Leo Company Bal | SolutionInn", "meta_keywords": "attached,auto,graded,spreadsheet,change,macros,tabs,leo,company,balance,sheet,december", "question_title_h1": "Please see attached auto graded spreadsheet, you MUST not change any of the macros in any of the tabs. Leo Company Balance Sheet As of", "question_title": "Please see attached auto graded spreadsheet, you MUST not change any of", "question_title_for_js_snippet": "Please see attached auto graded spreadsheet, you MUST not change any of the macros in any of the tabs Leo Company Balance Sheet As of December 31, 2015 ASSETS Current Assets Cash Accounts Receivable Prepaid Insurance Inventory Total Currents Assets Property, Plant, Equipment Land Equipment Accumulated Depreciation Total PPE Total Assets LIAB STOCKHOLDERS EQUITY Current Liabilities Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable Total Current Liabilities Long Term Debt Stockholders Equity Common Stock Retained Earnings Total Stockholders Equity Total liab SE $ $ $ $ $ $ $ $ $ $ $ $ 15,200 129,600 10,800 $ 155,600 $ $ 30,000 185,600 $ $ 22,928 140,000 $ $ 22,672 185,600 10,000 40,000 (20,000) 9,828 8,100 5,000 $ 0 10,000 12,672 January Expected Sales Units Unit Sales Price Expected Growth of Sales (monthly growth) Percentage of Cash Sales 2,400 $110 2 40 Collections of Accounts Receivable Month of Sale Month following Sale 10 90 Cost of Goods Sold percentage of sales 62 Inventory Purchase Information Purchases paid in current month Purchases paid in next month Purchases are all on credit Planned ending inventory as a percentage of next month's Cost of Goods Sold 80 20 10 Sales Commission Information Sales commissions as a percentage of sales Sales commissions are paid the month after they are incurred Supplies Expense Fixed Cost portion Variable Rate Insurance policy Information of months of insurance coverage paid for each year The policy period is from January 1 through December 31 each year The premium was paid on January 1 The premium will be recorded initially to prepaid insurance Other Selling Admin Expenses Salaries Expense Rent Expense Advertising Expense Utilities Expense 5 $4,000 2 12 $24,000 $12,000 $4,500 $3,000 $1,200 Selling and administrative expenses are paid in the month incurred Fixed Asset Information Purchase Land on January 31 Current Depreciation expense per month Long Term Loan Interest Information The interest rate on the long term debt per month is Interest is paid on the principle balance at the beginning of the month Minimum Cash Balance New borrowing must be in $1,000 increments 58,000 1,000 1 $15,000 Tax Information Income tax rate Taxes are paid in the month after they are incurred (expensed) Dividend Information Cash dividend declared in January Cash dividend paid in February 25 $10,000 of sales of sales Leo Company Sales Budget For the first quarter January February There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct 0 Part 1 Sales Cash Sales Credit Sales Total Sales Part 2 Cash Receipts From Cash Sales From Credit Sales this month From Credit Sales last month Total Cash Receipts March April Leo Company Inventory Purchases Budget For the first quarter January Part 1 Inventory Purchases Cost of Sales Desired Ending Inventory Inventory Needs Less Beginning Inventory Total Inventory Purchases Part 2 Cash Payments From inventory purchases this month From inventory purchases last month Total Cash Payments There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct 0 February March April Leo Company Selling and Administrative Expense Budget For the first quarter January Part 1 Variable Selling Admin Expenses Commissions Expense Supplies Expense Total Variable Selling Admin Expenses Part 2 Fixed Selling Admin Expenses Supplies Expense Salaries Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Total Fixed Selling Admin Expenses Part 3 Cash Payments for Selling Admin Expenses Commissions Expense Supplies Expense Salaries Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Total Cash Payments for Selling Admin Expenses There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct 8 February March Leo Company Cash Budget For the first quarter January Part 1 Cash Available Beginning Cash Cash Receipts Total Cash Available Part 2 Cash Payments For Inventory Purchases For Selling Administrative Expenses For Land For Interest For Dividends For Taxes Total Cash Payments Part 3 Financing Cash Surplus (Cash Deficit) New Borrowing (Long Term Debt Repayments) Ending Cash Long Term Debt Beginning Balance of Long Term Debt New Borrowing Less Repayments of Long Term Debt Ending Balance Long Term Debt There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct 14 February March Note Sign ( ) of these values matters Leo Company Proforma Income Statement For the first quarter January Sales Less Variable Costs Cost of Goods Sold Variable Selling Admin Expenses Contribution Margin Less Fixed Costs Fixed Selling Admin Expenses Interest Expense Income Before Taxes Income Taxes Net Income There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct 0 February March Leo Company Balance Sheet As of the end month January ASSETS Current Assets Cash Accounts Receivable Prepaid Insurance Inventory Total Currents Assets Property, Plant, Equipment Land Equipment Accumulated Depreciation Total PPE Total Assets $ $ $ LIAB STOCKHOLDERS EQUITY Current Liabilities Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable Total Current Liabilities Long Term Debt Stockholders Equity Common Stock Retained Earnings Total Stockholders Equity Total liab SE $ $ $ There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct 4 February March $ $ $ $ $ $ $ $ $ $ $ $ Unit Sales Sales Cost of Sales Gross Profit Operating Expenses Commissions Expense Salaries Supplies Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Interest Expense Pretax Income Income Tax Expense Net Income Actual Results 2,125 $244,375 $144,500 $99,875 $9,775 $12,500 $11,331 $4,800 $2,000 $1,000 $1,300 $2,050 $1,400 $53,719 $4,000 $49,719 Units Sales Cost of Sales Gross Profit Operating Expenses Commissions Expense Salaries Supplies Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Interest Expense Pretax Income Income Tax Expense Net Income Planning Budget 2,400 There is AT LEAST one error on this sheet Percentage of this Sheet that is correct Activity Variances 10 45 F U Flexible Budget 2,125 Revenue Spending Variances F U Actual Results 2,125 $244,375 $144,500 $99,875 $9,775 $12,500 $11,331 $4,800 $2,000 $1,000 $1,300 $2,050 $1,400 $53,719 $4,000 $49,719 Planning Budget Sales Less Variable Costs Cost of Goods Sold Commissions Supplies Contibution Margin Less Fixed Costs Supplies Salaries Rent Advertising Depreciation Utilities Insurance Interest Income Before Taxes Income Tax Expense Net Income Contribution Margin Percentage (Ratio) Sales at Breakeven Point Dollar Margin of Safety Sales needed to achieve a $50,000 before tax income Sales needed to achieve a $50,000 after tax net income There is AT LEAST one error on this sheet Percentage of this Sheet that is correct 0 00 Take home Exam Grade Points on Take Home Exam (out of 100) 7 6 583072", "question_description": "

Please see attached auto graded spreadsheet, you MUST not change any of the macros in any of the tabs.<\/p>\"image Leo Company Balance Sheet As of December 31, 2015 ASSETS: Current Assets Cash Accounts Receivable Prepaid Insurance Inventory Total Currents Assets Property, Plant, & Equipment Land Equipment Accumulated Depreciation Total PPE Total Assets LIAB & STOCKHOLDERS EQUITY Current Liabilities Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable Total Current Liabilities Long Term Debt Stockholders Equity Common Stock Retained Earnings Total Stockholders Equity Total liab & SE $ $ $ $ $ $ $ $ $ $ $ $ 15,200 129,600 10,800 $ 155,600 $ $ 30,000 185,600 $ $ 22,928 140,000 $ $ 22,672 185,600 10,000 40,000 (20,000) 9,828 8,100 5,000 $-0- 10,000 12,672 January Expected Sales Units Unit Sales Price Expected Growth of Sales (monthly growth) Percentage of Cash Sales 2,400 $110 2% 40% Collections of Accounts Receivable Month of Sale Month following Sale 10% 90% Cost of Goods Sold percentage of sales 62% Inventory Purchase Information Purchases paid in current month Purchases paid in next month Purchases are all on credit Planned ending inventory as a percentage of next month's Cost of Goods Sold 80% 20% 10% Sales Commission Information Sales commissions as a percentage of sales Sales commissions are paid the month after they are incurred. Supplies Expense Fixed Cost portion Variable Rate Insurance policy Information # of months of insurance coverage paid for each year The policy period is from January 1 through December 31 each year The premium was paid on January 1 The premium will be recorded initially to prepaid insurance Other Selling & Admin Expenses Salaries Expense Rent Expense Advertising Expense Utilities Expense 5% $4,000 2% 12 $24,000 $12,000 $4,500 $3,000 $1,200 Selling and administrative expenses are paid in the month incurred Fixed Asset Information Purchase Land on January 31 Current Depreciation expense per month Long-Term Loan Interest Information The interest rate on the long-term debt per month is Interest is paid on the principle balance at the beginning of the month Minimum Cash Balance New borrowing must be in $1,000 increments 58,000 1,000 1% $15,000 Tax Information Income tax rate Taxes are paid in the month after they are incurred (expensed) Dividend Information Cash dividend declared in January Cash dividend paid in February 25% $10,000 of sales of sales Leo Company Sales Budget For the first quarter January February There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct: 0% Part 1: Sales Cash Sales Credit Sales Total Sales Part 2: Cash Receipts From Cash Sales From Credit Sales this month From Credit Sales last month Total Cash Receipts March April Leo Company Inventory Purchases Budget For the first quarter January Part 1: Inventory Purchases Cost of Sales Desired Ending Inventory Inventory Needs Less: Beginning Inventory Total Inventory Purchases Part 2: Cash Payments From inventory purchases this month From inventory purchases last month Total Cash Payments There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct: 0% February March April Leo Company Selling and Administrative Expense Budget For the first quarter January Part 1: Variable Selling & Admin Expenses Commissions Expense Supplies Expense Total Variable Selling & Admin Expenses Part 2: Fixed Selling & Admin Expenses Supplies Expense Salaries Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Total Fixed Selling & Admin Expenses Part 3: Cash Payments for Selling & Admin Expenses Commissions Expense Supplies Expense Salaries Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Total Cash Payments for Selling & Admin Expenses There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct: 8% February March Leo Company Cash Budget For the first quarter January Part 1: Cash Available Beginning Cash Cash Receipts Total Cash Available Part 2: Cash Payments For Inventory Purchases For Selling & Administrative Expenses For Land For Interest For Dividends For Taxes Total Cash Payments Part 3: Financing Cash Surplus (Cash Deficit) New Borrowing (Long Term Debt Repayments) Ending Cash Long-Term Debt Beginning Balance of Long-Term Debt New Borrowing Less: Repayments of Long-Term Debt Ending Balance Long Term Debt There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct: 14% February March Note: Sign (+\/-) of these values matters. Leo Company Proforma Income Statement For the first quarter January Sales Less: Variable Costs Cost of Goods Sold Variable Selling & Admin Expenses Contribution Margin Less: Fixed Costs Fixed Selling & Admin Expenses Interest Expense Income Before Taxes Income Taxes Net Income There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct: 0% February March Leo Company Balance Sheet As of the end month January ASSETS: Current Assets Cash Accounts Receivable Prepaid Insurance Inventory Total Currents Assets Property, Plant, & Equipment Land Equipment Accumulated Depreciation Total PPE Total Assets $ - $ $ - LIAB & STOCKHOLDERS EQUITY Current Liabilities Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable Total Current Liabilities Long Term Debt Stockholders Equity Common Stock Retained Earnings Total Stockholders Equity Total liab & SE $ - $ $ - There is AT LEAST ONE ERROR on this sheet Percentage of this sheet that is correct: 4% February March $ - $ - $ $ - $ $ - $ - $ - $ $ - $ $ - Unit Sales Sales Cost of Sales Gross Profit Operating Expenses Commissions Expense Salaries Supplies Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Interest Expense Pretax Income Income Tax Expense Net Income Actual Results 2,125 $244,375 $144,500 $99,875 $9,775 $12,500 $11,331 $4,800 $2,000 $1,000 $1,300 $2,050 $1,400 $53,719 $4,000 $49,719 Units Sales Cost of Sales Gross Profit Operating Expenses Commissions Expense Salaries Supplies Expense Rent Expense Advertising Expense Depreciation Expense Utilities Expense Insurance Expense Interest Expense Pretax Income Income Tax Expense Net Income Planning Budget 2,400 There is AT LEAST one error on this sheet Percentage of this Sheet that is correct: Activity Variances 10.45% F\/U Flexible Budget 2,125 Revenue\/Spending Variances F\/U Actual Results 2,125 $244,375 $144,500 $99,875 $9,775 $12,500 $11,331 $4,800 $2,000 $1,000 $1,300 $2,050 $1,400 $53,719 $4,000 $49,719 Planning Budget Sales Less: Variable Costs Cost of Goods Sold Commissions Supplies Contibution Margin Less: Fixed Costs Supplies Salaries Rent Advertising Depreciation Utilities Insurance Interest Income Before Taxes Income Tax Expense Net Income Contribution Margin Percentage (Ratio) Sales at Breakeven Point Dollar Margin of Safety Sales needed to achieve a $50,000 before tax income Sales needed to achieve a $50,000 after tax net income There is AT LEAST one error on this sheet Percentage of this Sheet that is correct: 0.00% Take-home Exam Grade Points on Take-Home Exam (out of 100) 7% 6.583072", "transcribed_text": "", "related_book": { "title": "Auditing Cases An Active Learning Approach", "isbn": "0130674842, 978-0130674845", "edition": "2nd Edition", "authors": "Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/64ed8a8041add_6938.jpg", "uri": "\/textbooks\/abnormal-psychology-clinical-perspectives-on-psychological-disorders-1st-edition-9781266566899", "see_more_uri": "" }, "free_related_book": { "isbn": "3030436926", "uri": "\/textbooks\/innovations-in-urban-and-regional-systems-contributions-from-gisandt-spatial-analysis-and-location-modeling-1st-edition-978-3030436926-278577", "name": "Innovations In Urban And Regional Systems Contributions From Gisandt Spatial Analysis And Location Modeling", "edition": "1st Edition" }, "question_posted": "2024-06-28 06:45:21", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/consider-the-potato-chip-production-process-at-a-company-such", "description": "Consider the potato chip production process at a company such as Frito-Lay . Frito-Lay uses a continuous flow technology that is suited for high volumes of product. At the Plano, Texas, facility,...", "stars": 3 }, { "url": "\/study-help\/psychology\/4-what-causes-someone-to-persist-or-to-give-up-1984147", "description": "4. What causes someone to persist or to give up? Will a student read the entire Shakespeare assignment or just a few pages?", "stars": 3 }, { "url": "\/electro-ltd-has-just-commenced-operations-under-ideal-conditions-of", "description": "Electro Ltd. has just commenced operations under ideal conditions of uncertainty. Its cash flows will depend crucially on the state of the economy. On January 1, 2015, the company acquired plant and...", "stars": 3 }, { "url": "\/study-help\/questions\/write-answer-in-python-create-a-function-pointdistance-that-take-9862389", "description": "Write Answer in Python Create a function (point_distance) that take four inputs (x1,y1,x2, and y2 ) and calculates and returns the distance (d) between two points using the distance formula. Use the...", "stars": 3 }, { "url": "\/study-help\/questions\/find-the-reference-number-tbar-and-the-terminal-point-for-2054625", "description": "Find the Reference Number (t-bar) and the Terminal Point for each value of t. To receive full credit, you must clearly show how you got these numbers by drawing a Unit Circle and showing what tis (0)...", "stars": 3 }, { "url": "\/study-help\/questions\/eastpoint-toyota-a-small-dealership-has-provided-you-with-the-1841818", "description": "EastPoint Toyota, a small dealership, has provided you with the following information with respect to its vehicle inventory for the month of November. The company uses the specific identification...", "stars": 3 }, { "url": "\/study-help\/questions\/the-following-information-refers-to-parts-12-it-contains-dropdown-4916365", "description": "The following information refers to parts 1-2. It contains drop-down multiple choice and numerical questions. There are two periods (0 and 1). There are three states and two securities, a bond and a...", "stars": 3 }, { "url": "\/study-help\/questions\/the-trial-balance-for-skylar-plc-as-at-31-october-1224270", "description": "The trial balance for Skylar plc as at 31 October 20X7 is shown below. '000 '000 Share capital 15,000 Trade payables 3,348 Trade receivables 10,254 Accruals at 31 October 20X7 387 5% bank loan...", "stars": 3 }, { "url": "\/study-help\/questions\/john-and-mary-hazlitt-left-the-airport-taxi-and-carried-1226996", "description": "John and Mary Hazlitt left the airport taxi and carried their bags into their high - rise apartment building. They admired the gifts they had brought back - an illustrated book for themselves; a...", "stars": 3 }, { "url": "\/study-help\/questions\/the-assessable-unit-manager-aum-meets-with-the-external-independent-1242670", "description": "The Assessable Unit Manager (AUM) meets with the external Independent Auditor (IPA) to prepare and submit the Annual Statement of Assurance (ASOA) feeder package to the Head of the Reporting...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/which-of-the-following-statement-is-correct-with-respect-to-4254963", "next": "\/study-help\/questions\/i-need-to-start-a-new-business-dry-cleaning-and-4254965" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Please see attached auto graded spreadsheet, you MUST not change any of", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/please-see-attached-auto-graded-spreadsheet-you-must-not-change-4254964" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }d": "1" } }