Question 1 The “Question 1” tab of the spreadsheet contains the most recent (“Year 0”) income statement for Thestral Corporation. You’ll need to forecast the next 5 years of the income statement...

1 answer below »

View more »
Answered Same DayAug 28, 2022

Answer To: Question 1 The “Question 1” tab of the spreadsheet contains the most recent (“Year 0”) income...

S answered on Aug 29 2022
72 Votes
Question 1
    Thestral Corporation
        Year 0    Year 1    Year 2    Year 3    Year 4    Year 5
    Sales    $ 25,000,00
0    $ 27,250,000    $ 29,702,500    $ 32,375,725    $ 35,289,540    $ 38,465,599
    Cost of Goods Sold    $ 11,000,000    $ 11,990,000    $ 13,069,100    $ 14,245,319    $ 15,527,398    $ 16,924,864
    Gross Profit    $ 14,000,000    $ 15,260,000    $ 16,633,400    $ 18,130,406    $ 19,762,143    $ 21,540,735
    Selling, General and Administrative Costs    $ 4,500,000    $ 4,905,000    $ 5,346,450    $ 5,827,631    $ 6,352,117    $ 6,923,808
    Depreciation    $ 1,000,000    $ 1,070,000    $ 1,144,900    $ 1,225,043    $ 1,310,796    $ 1,402,552
    Earnings Before Interest and Tax (EBIT)    $ 8,500,000    $ 9,285,000    $ 10,142,050    $ 11,077,733    $ 12,099,229    $ 13,214,376
    Interest Expense    $ 600,000    $ 672,000    $ 752,640    $ 842,957    $ 944,112    $ 1,057,405
    Earnings Before Tax    $ 7,900,000    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30