Forecast the income statement and balance sheet Lululemon Athletica for the next five years (end of fiscal 2015 to end of 2020) In one sheet of your file, explain your assumptions point by point You do not need to write long stories For examples, you can explain in one or two sentences each why you chose the size of fixed assets or cost of goods sold the way you did Some key items might need more explanation Your balance sheet must balance Your retained earnings on the balance sheet must only change by the retained earnings for the year carried on to it from the income statement of that year Balance Sheet (2015 2010) Assets 2015 2014 2013 2012 2011 2010 Cash And Cash Equivalents 664479 698649 590179 409437 316286 159573 Short Term Investments Net Receivables 13746 11903 6351 5202 9116 8238 Inventory 208116 188790 155222 104097 57469 44070 Other Current Assets 64671 46197 35301 8357 6408 4529 Long Term Investments Property Plant and Equipment 296008 255306 214639 162941 70954 61591 Goodwill Intangible Assets 26163 28201 30201 31872 27112 8050 Accumulated Amortization Other Assets 7012 4745 4152 4141 4063 6105 Deferred Long Term Asset Charges 16018 18300 15033 8587 7894 15102 Total Assets $1,296,213 $1,252,091 $1,051,078 $734,634 $499,302 $307,258 Liabilities Shareholders' Equity Accounts Payable 113629 77871 98244 80666 67196 46979 Short Current Long Term Debt Other Current Liabilities 46252 38343 35113 22773 18168 11699 Total Current Liabilities $ 159,881 $ 116,214 $ 133,357 $103,439 $ 85,364 $ 58,678 Long Term Debt Other Liabilities 43131 35515 30422 25014 19645 15472 Deferred Long Term Liability Charges 3633 3977 Minority Interest Negative Goodwill Total Liabilities $ 206,645 $ 155,706 $ 163,779 $128,453 $105,009 $ 74,150 Misc Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock 661 577 562 551 534 511 Retained Earnings 1020619 923822 644275 373719 189656 67809 Treasury Stock Capital Surplus 241695 240351 221372 205557 179870 158921 Other Stockholder Equity 173407 68068 21090 21549 20329 5867 Total Stockholder Equity $1,089,568 $1,096,682 $ 887,299 $601,379 $390,389 $233,108 Income Statement (2015 2010) Period Ending 1 Feb 15 1 Feb 14 1 Feb 13 1 Feb 12 1 Feb 11 1 Feb 10 Total Revenue $ 1,797,213 $ 1,591,188 $ 1,370,358 $ 1,000,839 $ 711,704 $ 452,898 Cost of Revenue $ 883,033 $ 751,112 $ 607,532 $ 431,488 $ 316,757 $ 229,812 Gross Profit $ 914,180 $ 840,076 $ 762,826 $ 569,351 $ 394,947 $ 223,086 Operating Expenses Selling General and Administrative $ 538,147 $ 448,718 $ 386,387 $ 282,393 $ 212,784 $ 136,161 Non Recurring $ 1,722 $ 379 Total Operating Expenses $ 376,033 $ 391,358 $ 376,439 $ 286,958 $ 180,441 $ 86,546 Income from Continuing Operations Total Other Income Expenses Net $ 7,102 $ 5,768 $ 4,957 $ 2,500 $ 2,886 $ 164 Earnings Before Interest And Taxes $ 383,135 $ 397,126 $ 381,396 $ 289,458 $ 183,327 $ 86,710 Interest Expense Income Before Tax $ 383,135 $ 397,126 $ 381,396 $ 289,458 $ 183,327 $ 86,710 Income Tax Expense $ 144,102 $ 117,579 $ 109,965 Minority Interest $ (875) $ (901) $ (350) Net Income Applicable To Common Shares $ 239,033 $ 279,547 $ 270,556 $ 184,063 $ 121,847 $ 58,281

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 07, 2024

Forecast the income statement and balance sheet Lululemon Athletica for the next five years (end of fiscal 2015 to end of 2020). In one sheet

Forecast the income statement and balance sheet Lululemon Athletica for the next five years (end of fiscal 2015 to end of 2020). In one sheet of your file, explain your assumptions point by point. You do not need to write long stories. For examples, you can explain in one or two sentences each why you chose the size of fixed assets or cost of goods sold the way you did. Some key items might need more explanation.Your balance sheet must balance. Your retained earnings on the balance sheet must only change by the retained earnings for the year carried on to it from the income statement of that year.

Balance Sheet (2015-2010)
Assets	2015	2014	2013	2012	2011	2010
Cash And Cash Equivalents	664479	698649	590179	409437	316286	159573
Short Term Investments	-	-	-	-	-	-
Net Receivables	13746	11903	6351	5202	9116	8238
Inventory	208116	188790	155222	104097	57469	44070
Other Current Assets	64671	46197	35301	8357	6408	4529
Long Term Investments	-	-	-	-	-	-
Property Plant and Equipment	296008	255306	214639	162941	70954	61591
Goodwill	-	-	-	-	-
Intangible Assets	26163	28201	30201	31872	27112	8050
Accumulated Amortization	-	-	-	-	-	-
Other Assets	7012	4745	4152	4141	4063	6105
Deferred Long Term Asset Charges	16018	18300	15033	8587	7894	15102
Total Assets	$1,296,213	$1,252,091	$1,051,078	$734,634	$499,302	$307,258

Liabilities & Shareholders' Equity
Accounts Payable	113629	77871	98244	80666	67196	46979
Short/Current Long Term Debt	-	-	-	-	-	-
Other Current Liabilities	46252	38343	35113	22773	18168	11699
Total Current Liabilities	$ 159,881	$ 116,214	$ 133,357	$103,439	$ 85,364	$ 58,678
Long Term Debt	-	-	-
Other Liabilities	43131	35515	30422	25014	19645	15472
Deferred Long Term Liability Charges	3633	3977	-	-	-	-
Minority Interest	-	-	-	-	-	-
Negative Goodwill	-	-	-	-	-	-
Total Liabilities	$ 206,645	$ 155,706	$ 163,779	$128,453	$105,009	$ 74,150
Misc Stocks Options Warrants	-	-	-	-	-	-
Redeemable Preferred Stock	-	-	-	-	-	-
Preferred Stock	-	-	-	-	-	-
Common Stock	661	577	562	551	534	511
Retained Earnings	1020619	923822	644275	373719	189656	67809
Treasury Stock	-	-	-	-
Capital Surplus	241695	240351	221372	205557	179870	158921
Other Stockholder Equity	-173407	-68068	21090	21549	20329	5867
Total Stockholder Equity	$1,089,568	$1,096,682	$ 887,299	$601,379	$390,389	$233,108

Income Statement (2015-2010)
Period Ending	1-Feb-15	1-Feb-14	1-Feb-13	1-Feb-12	1-Feb-11	1-Feb-10
Total Revenue	$ 1,797,213	$ 1,591,188	$ 1,370,358	$ 1,000,839	$ 711,704	$ 452,898
Cost of Revenue	$ 883,033	$ 751,112	$ 607,532	$ 431,488	$ 316,757	$ 229,812
Gross Profit	$ 914,180	$ 840,076	$ 762,826	$ 569,351	$ 394,947	$ 223,086
Operating Expenses:
Selling General and Administrative	$ 538,147	$ 448,718	$ 386,387	$ 282,393	$ 212,784	$ 136,161
Non Recurring	-	-	-	-	$ 1,722	$ 379
Total Operating Expenses	$ 376,033	$ 391,358	$ 376,439	$ 286,958	$ 180,441	$ 86,546

Income from Continuing Operations:
Total Other Income/Expenses Net	$ 7,102	$ 5,768	$ 4,957	$ 2,500	$ 2,886	$ 164
Earnings Before Interest And Taxes	$ 383,135	$ 397,126	$ 381,396	$ 289,458	$ 183,327	$ 86,710
Interest Expense	-	-	-	-	-	-
Income Before Tax	$ 383,135	$ 397,126	$ 381,396	$ 289,458	$ 183,327	$ 86,710
Income Tax Expense	$ 144,102	$ 117,579	$ 109,965	-	-	-
Minority Interest	-	-	$ (875)	$ (901)	$ (350)	-
Net Income Applicable To Common Shares	$ 239,033	$ 279,547	$ 270,556	$ 184,063	$ 121,847	$ 58,281