Construct an Income Statement for Maxus Manufacturing, for the year ending December 31, 2021, given the following information. Total Sales was $385 million. Other Expenses (excludi

You must upload an Excel spreadsheet for your assignment, with formulas showing all calculations.
Please answer the following questions. All numbers should be in thousands of dollars.
Problem 1
Construct an Income Statement for Maxus Manufacturing, for the year ending December 31, 2021, given the following information.
Total Sales was $385 million.
Other Expenses (excluding Depreciation & Amortization) was $21.2 million.
EBITDA was 23.4% of Sales.
Depreciation & Amortization was 4.5% of Gross Fixed Assets.
Interest Expense was 3.9% of Long-Term Debt.
The corporate tax rate for the company is 19%.
Net Fixed Assets at the start of 2021 was $276 million. Accumulated Depreciation at the start of 2021 was $98 million. No new fixed assets were acquired during 2021, and none were sold or retired.
Long-Term Debt on December 31, 2020 totaled $425 million. The next principal payment will take place on December 31, 2023. No additional interest-bearing debt was incurred during 2021.
Problem 2
Construct a full Statement of Shareholders Equity for Globe Services, as of December 31, 2021, given the following information.
As of December 31, 2020, there were 40 million shares of stock outstanding, sold by the company to shareholders for a total of $119 million.
On March 11, 2021, an additional 3 million shares were sold by the company to shareholders for $15 million. No other shares were sold or bought back in 2021.
Net Income for the year ending December 31, 2021 was $57 million.
During 2021, $11 million of cash dividends were declared and paid to shareholders.
As of December 31, 2021, total Shareholders Equity was $1,408 million.
Requirements: 2 pages
You must upload an Excel spreadsheet for your assignment, with formulas showing all calculations.
Please answer the following questions. All numbers should be in thousands of dollars.
Problem 1
Construct an Income Statement for Maxus Manufacturing, for the year ending December?31,?2021, given the following information.
Total Sales was $385?million.
Other Expenses (excluding Depreciation & Amortization) was $21.2?million.
EBITDA was 23.4% of Sales.
Depreciation & Amortization was 4.5% of Gross Fixed Assets.
Interest Expense was 3.9% of Long-Term Debt.
The corporate tax rate for the company is 19%.
Net Fixed Assets at the start of 2021 was $276?million. Accumulated Depreciation at the start of 2021 was $98?million. No new fixed assets were acquired during 2021, and none were sold or retired.
Long-Term Debt on December 31, 2020 totaled $425?million. The next principal payment will take place on December 31, 2023. No additional interest-bearing debt was incurred during 2021.
Problem 2
Construct a full Statement of Shareholders Equity for Globe Services, as of December?31,?2021, given the following information.
As of December 31, 2020, there were 40?million shares of stock outstanding, sold by the company to shareholders for a total of $119?million.
On March 11, 2021, an additional 3?million shares were sold by the company to shareholders for $15?million. No other shares were sold or bought back in 2021.
Net Income for the year ending December 31, 2021 was $57?million.
During 2021, $11?million of cash dividends were declared and paid to shareholders.
As of December 31, 2021, total Shareholders Equity was $1,408?million.
Good luck!

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.