(Get Answer)
Expert Answer
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!
This question has already been tackled by one of our writers and a good grade recorded. You can equally get high grades by simply making your order for this or any other school assignment that you may have.
Every Student Buys Essays from us, here is why!
Pressed for time to complete assignments or when you feel like you cannot write, you can purchase an
essay on our website. Some students also want model papers to use as samples when revising or
writing. There are also students who approach our essay writing service to beat deadlines. We handle
every type of homework, assignment, and academic writing tasks. You can buy college essays and other
assignments here. At a glance, here are some reasons students prefer our website.
100% Original Essays and Papers
You can be sure that you are getting a paper that is custom written based on your instructions. We do
not sell papers that are pre-written. Instead, we write every essay from scratch. When you say “write my
essay,” we respond by giving you a paper that is 100% original and free of any plagiarism. The essays you
purchase from us have never been sold anywhere.
Flexible & Affordable Prices
It does not cost a fortune to get academic writing help on our website. If you have a question from class,
place an order, get a discount, and get cheap essay writing services. What you see as the price is what
you pay for. There are no any hidden charges. If you need urgent papers, they might cost a little more,
but the price is worth the quality you get in the end. Hire a professional academic writer beginning from
$13 a page.
Anonymity, Privacy, and Confidentiality
No one will ever know that you purchased an essay or assignment from our website. The essays you buy
from us are written by experts. Your data is only used to coordinate the essay writing services you get.
No one can access your personal information and data. Go ahead and order an essay from our website.
It is safe, secure, and convenient.
