Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The professor said at the end there should be a total of 270 numerical entries. BUDGETING AND PRO FORMA FINANCIAL STATEMENT ASSIGNMENT MANAGERIAL ACCOUNTING DUE

image text in transcribed
image text in transcribed
image text in transcribed
The professor said at the end there should be a total of 270 numerical entries.
BUDGETING AND PRO FORMA FINANCIAL STATEMENT ASSIGNMENT MANAGERIAL ACCOUNTING DUE APRIL 22.2021 You are the newly appointed accounting manager for a new, startup business scheduled to open its doors and begin operations at its new retail location on April 1, 2021. The new company, Thompson Softball, Inc. will sell high end softball equipment. The owner of the company has gone to the local bank to borrow money for equipment and fixtures needed to run the business The loan manager, at the bank, has requested that he, the owner, provide the following to the bank in order to allow the bank to make a credit approval decision: (i) sales budget; (ii) inventory purchases budget: (im) a selling and administrative expense budget; and (iva cash budget for the months of April, May and June of 2021. In addition the company plans on having semi- annual pro forma financial statements prepared for the period ending June 30, 2021. The lean manager has also requested that owner provide the following pro forma financial statements for the period ending June 30, 2021: (i) income statement; (ii) balance sheet; and (ii) a statement of cash flows. The loan manager wants the various budgets and pro forma financial statements prepared using the correct format that you learned in your managerial accounting class while a Bethany College. The owner has asked you to prepare what was requested by the bank. RELEVANT INFORMATION NEEDED TO PREPARE YOUR WORK Sales for the month of April are expected to be s 200,000.00 and for the next three months, sales will increase 25% from the previous month. 30% of all sales are cash and the balance of sales in the month are on account and collected the month following the sale. Thompson Softball, Inc.'s gross margin is 30%. The company's policy is to maintain an ending inventory that is equal to 25% of the following month's sales. All inventory is purchased on account with 50% being paid for in the month of purchase and balance paid the month following the purchase of inventory inspection period, with proceeds from the loan. The interest rate on the loan is 12% annually or 1% per month with interest being paid on the Last day of the month based on the outstanding indebtedness on the last day of the previous month. No interest being paid in April. The following are the selling and administrative expenses that the company expects to incurcach of the three months. Salary Expense $2,500.00 Sales Commissions 2% of Sales, paid the month following the sales Supplies Expense 1% of Sales Utilities Expense $ 1.200.00 per month paid the following month Depreciation per the information provided in Item 6. Rent Expense $ 2.500.00 per month Miscellaneous Expenses S 700.00 per month Interest Expense per the terms in item The company's beginning cash balance on Aprillis S 00.00 and the company's policy is to maintain a month ending cash balance of 15,000.00. Any shortages are made up with borrowings from the local bank with the same terms as the original loan. Any surpluses at month end beyond the S 15,000.00 is used to pay down the indebtedness. Any borrowings or repayment will be in even increments of S1000.00. ROUND ALL NUMBERS IN AN UPWARD FASHION TO THE NEXT DOLLAR. THE OWNER EXPECTS THE BUDGETS AND PRO FORMA FINANCIAL STATEMENTS TO BE PREPARED BY APRIL 22. 2021. USING THE CORRECT BUDGET AND PRO FORMA FINANCIAL STATEMENT FORMATS YOUR WORK SHOULD ALL BE DONE BY HAND NOT COMPUTER AND THE PROPER FORMAT AS ILLUSTRATED IN THE TEXT!!!!!! EVERY DAY THIS ASSIGNMENT IS LATE WILL RESULT IN A5% POINT REDUCTION FROM THE TOTAL 200 POINTS AVAILABLE!!! 2 BUDGETING AND PRO FORMA FINANCIAL STATEMENT ASSIGNMENT MANAGERIAL ACCOUNTING DUE APRIL 22.2021 You are the newly appointed accounting manager for a new, startup business scheduled to open its doors and begin operations at its new retail location on April 1, 2021. The new company, Thompson Softball, Inc. will sell high end softball equipment. The owner of the company has gone to the local bank to borrow money for equipment and fixtures needed to run the business The loan manager, at the bank, has requested that he, the owner, provide the following to the bank in order to allow the bank to make a credit approval decision: (i) sales budget; (ii) inventory purchases budget: (im) a selling and administrative expense budget; and (iva cash budget for the months of April, May and June of 2021. In addition the company plans on having semi- annual pro forma financial statements prepared for the period ending June 30, 2021. The lean manager has also requested that owner provide the following pro forma financial statements for the period ending June 30, 2021: (i) income statement; (ii) balance sheet; and (ii) a statement of cash flows. The loan manager wants the various budgets and pro forma financial statements prepared using the correct format that you learned in your managerial accounting class while a Bethany College. The owner has asked you to prepare what was requested by the bank. RELEVANT INFORMATION NEEDED TO PREPARE YOUR WORK Sales for the month of April are expected to be s 200,000.00 and for the next three months, sales will increase 25% from the previous month. 30% of all sales are cash and the balance of sales in the month are on account and collected the month following the sale. Thompson Softball, Inc.'s gross margin is 30%. The company's policy is to maintain an ending inventory that is equal to 25% of the following month's sales. All inventory is purchased on account with 50% being paid for in the month of purchase and balance paid the month following the purchase of inventory inspection period, with proceeds from the loan. The interest rate on the loan is 12% annually or 1% per month with interest being paid on the Last day of the month based on the outstanding indebtedness on the last day of the previous month. No interest being paid in April. The following are the selling and administrative expenses that the company expects to incurcach of the three months. Salary Expense $2,500.00 Sales Commissions 2% of Sales, paid the month following the sales Supplies Expense 1% of Sales Utilities Expense $ 1.200.00 per month paid the following month Depreciation per the information provided in Item 6. Rent Expense $ 2.500.00 per month Miscellaneous Expenses S 700.00 per month Interest Expense per the terms in item The company's beginning cash balance on Aprillis S 00.00 and the company's policy is to maintain a month ending cash balance of 15,000.00. Any shortages are made up with borrowings from the local bank with the same terms as the original loan. Any surpluses at month end beyond the S 15,000.00 is used to pay down the indebtedness. Any borrowings or repayment will be in even increments of S1000.00. ROUND ALL NUMBERS IN AN UPWARD FASHION TO THE NEXT DOLLAR. THE OWNER EXPECTS THE BUDGETS AND PRO FORMA FINANCIAL STATEMENTS TO BE PREPARED BY APRIL 22. 2021. USING THE CORRECT BUDGET AND PRO FORMA FINANCIAL STATEMENT FORMATS YOUR WORK SHOULD ALL BE DONE BY HAND NOT COMPUTER AND THE PROPER FORMAT AS ILLUSTRATED IN THE TEXT!!!!!! EVERY DAY THIS ASSIGNMENT IS LATE WILL RESULT IN A5% POINT REDUCTION FROM THE TOTAL 200 POINTS AVAILABLE!!! 2

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

AQA AS Accounting Unit 1 Introduction To Financial Accounting

Authors: Brendan Casey

1st Edition

1499789653, 978-1499789652

More Books

Students also viewed these Finance questions

Question

Has time been designated in the schedule for collaboration?

Answered: 1 week ago