Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use an Excel spreadsheet for assignment, with formulas showing all calculations. All numbers should be in thousands of dollars. Construct an Income Statement for VEC

Use an Excel spreadsheet for assignment, with formulas showing all calculations. All numbers should be in thousands of dollars.

Construct an Income Statement for VEC Manufacturing, for the year ending December 31, 2020, given the following information.

  • Total Sales was $456 million.
  • Other Expenses (excluding Depreciation & Amortization) was $20.3 million.
  • EBITDA was 20.5% of Sales.
  • Depreciation & Amortization was 5% of Gross Fixed Assets.
  • Interest Expense was 8.4% of Long-Term Debt.
  • The corporate tax rate for VEC Manufacturing is 25%.
  • Net Fixed Assets at the start of 2020 was $287 million. Accumulated Depreciation at the start of 2020 was $123 million. No new fixed assets were acquired during 2020, and none were sold or retired.
  • Long-Term Debt on December 31, 2019 totaled $232 million. The next principal payment will take place on December 31, 2022. No additional interest-bearing debt was incurred during 2020.

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_2

Step: 3

blur-text-image_3

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

The Cyber Attack Survival Manual

Authors: Heather Vescent ,Nick Selby

1st Edition

1681886545, 978-1681886541

More Books

Students also viewed these Finance questions

Question

Describe the events of mitosis in sequence.

Answered: 1 week ago