Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
This is an excel assignment Budgeted Financial Statements You work as a staff accountant for a large, multinational manufacturing and distributions company. You work alongside
This is an excel assignment
Budgeted Financial Statements You work as a staff accountant for a large, multinational manufacturing and distributions company. You work alongside other staff accountants and have developed a close relationship with each of them. The company's fiscal year end is June 30, and next year's budgeted financials--with analyses--is expected by 5PM on July 5 (or the next business day). This is always a difficult turnaround period. Because of challenges with instituting the new accounting standards, closing entries took longer than expected, which delayed the start of budgeting the financial statements. Your team really doesn't want to work on July 4 to make up for being behind. Unfortunately, it's looking like you'll be spending the holiday in the office instead of barbequing and enjoying adult beverages on the local lake. Your team is responsible for completing the following budgeted statements & analyses A.) Budgeted income statement--contribution & gross margins B.) Budgeted balance sheet C.) Statement analyses consisting of: 1.) Working capital--last year was $2,684,286. Your team will be presenting the budgeted 2.) Current ratio--last year was 0.56. analyses to stockholders at the annual meeting. 3.) Quick/acid-test ratio--last year was 0.59. What would you say about the company's 4.) Profit margin--industry average is 12%. budgeted performance over last year/industry? Here is some information you'll need to construct the budgeted financial statements. These values represent budgeted values to be used directly into the budgeted financial statements. 1.) Budgeted sales $ 58,720,800 2.) Budgeted COGS Direct materials used S 5,797,776 Direct labor used 28,988,880 Overhead used 15.867.230 Total 50.653.886 Beginning finished goods 2.542.612 Goods available for sale 53.196,498 Ending finished goods (1.893,435) Budgeted COGS 51,303,063 3.) Total variable costs 51,601,472 4.) Selling & general admin costs 796,192 5.) Total fixed costs 497,784 6.) Interest expense 7% paid quarterly in the next quarter Q1 $ 3,620,000 Q2 7,420,000 4520000*7%*(3/12) 9,070,000 4,520,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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