Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the provided information to fill out the blank yellow sections in the bottom right chart ( in '000$) **include formulas. Actual Projected Income Statement

Use the provided information to fill out the blank yellow sections in the bottom right chart ( in '000$) **include formulas.

image text in transcribed
Actual Projected Income Statement (in '000 $) 2020 2021 Growth rates: 2022 2023 2024 2025 Total Assets 9.937 10,478 11,051 11,656 12,294 12,967 Parts Sales 3.5% 35% Service Program 3.5% 3.5% 5.2% 5.29% 5 2% Bank Loan 4.336 Parts Sales 2.121 2 195 2.272 2350 434 Payables 202 210 218 227 236 246 Service Program 3 122 3 284 13.454 5.635 CPLTD 46 Total Operating Revenues 5,243 5,475 5,726 61253 6.543 Other 90 101 103 105 107 109 Current Liabilities Salaries and benefits 4,683 358 369 381 393 1.028 406 1.069 1 112 1.156 1 20 LTD Research and development 733 733 733 733 1.050 733 1:113 733 1.180 1 251 1326 Equity 4521 Service expense 1521 321 4,521 4521 43 4521 456 481 507 535 564 Total Liabilities & Equity 9.937 5,612 5,623 Sales and Administrative 5,635 5,647 5,659 DD6 596 Depreciation/amortization 301 310 319 339 349 Working Capital 4,157 388 4,635 4.895 5,170 5,460 Total Operating Expenses 3.213 3.363 3,519 3.684 3,856 4,038 (in '000 $) 2021 2022 2023 2024 Income before taxes 2025 Income before taxes 2.030 2.117 2.208 + Interest 2,303 12.402 2.505 - Income before interest and taxes (EBIT) Income tax expense (benefit) 426 426 126 126 EBLAT Net Income 1.604 1.691 1,782 1,877 1.976 2,079 Change in Working Capital Balance Sheet Change in Other assets Cash and investments 1912 1988 2,068 2,151 2 23 2 326 Free Cash Flow (FCF) PV of FCF = EV Accounts receivable 1:385 1 482 1.586 1 697 1,816 1 943 -Existing Debt Inventory and supplies, net 1,109 = Value of equity 1,176 1.322 1.401 485 Other 98 103 106 109 112 Current Assets 4,504 4.746 5.004 5 276 5,866 ctions: On UX Accessibility: Investigate Focus

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

Intermediate Accounting

Authors: James D. Stice, Earl K. Stice, Fred Skousen

16th Edition

324376375, 0324375743I, 978-0324376371, 9780324375749, 978-0324312140

More Books

Students also viewed these Accounting questions