View the step-by-step solution to:

Construct a pro-forma income statement, balance sheet, and cash flow statement for fiscal year 2018 for Lowe's. Note that fiscal year 2018 will end...

Construct a pro-forma income statement, balance sheet, and cash flow statement for fiscal year 2018 for Lowe's. Note that fiscal year 2018 will end on February 1, 2019 and last 52 weeks. Fiscal 2017 also lasted 52 years, while fiscal year 2016 lasted 53 weeks (basing accounting on weeks is common in American retail). First, a list of assumptions is provided and then an outline for the three statements is given. Your answer must follow the outline while filling in all missing numbers. Remember to write supporting calculations or references (to line items found elsewhere) to the side (this is required to receive any credit). All numbers should be rounded to the nearest $ million. 


Assumptions for FY 2018 (YOY means year over year change from FY 2017)


Net sales will grow the same rate YOY as in FY 2017. Note that you must adjust the growth rate to account for difference in FY lengths.


The gross margin percentage is expected to increase by 1% from its FY 2017 level due to less intense competition (e.g., a 20% GMP in 2017 would imply a 21% GMP in 2018).


SG&A expense is expected to grow 5% YOY.


Depreciation and amortization is expected to be the same percentage of average property as in FY 2017 (use the D&A given in the income statement, not the cash flow statement).


Net interest is expected to be 4% of the average balance of debt.


There are no expected losses.


The effective tax rate in FY 2018 will be Federal (21%) plus average state tax (assumed to be the same state tax rate as in FY 2017 while other adjustments to the effective tax rate are assumed to be 0). See the footnotes for the information necessary when working this part. (page 60-61 in the Lowe's 2017 Annual Report)


Cash and equivalents will rise 2% YOY.


Short-term investments will decline 10% YOY.


Inventories will be the same percentage of cost of sales as in FY 2017.


Other current assets, long-term investments, deferred income taxes, and other assets will stay constant at FY 2017 levels. They can be combined into a single line item called other assets of $3,487 million


Capital expenditures will be $1.2 billion.


Combine all debt accounts (three of them). The capital structure will stay constant in FY 2018 (i.e. the ratio of total debt to total equity).


Accounts payable will be the same percentage of cost of sales as in FY 2017.


Deferred revenue will be the same percentage of sales as in FY 2016 adjusted for the difference in fiscal year length (the 2017 deferred revenue is historically high so we don't want to use it as a benchmark).


Deferred revenue - extended protection plans will be the same percentage of sales as in FY 2017.


All other liabilities can be combined and will stay constant at $3,652 million.




Layouts for the financial pro-formas

 

 

Income statement        FY ended February 1, 2019 (in $ million)


Net sales                                              

 

Cost of sales


____________________________________


Gross margin



SG&A


Depreciation and amortization

                                                                     

Net interest expense


                                                                      


Pre-tax income                       

 


Income tax expense

                                                                      


Net income



 

Balance sheet             February 1, 2019 (in $ million)


Cash and equivalents                         


Short-term investments              

 

Inventory


Property


Other assets                                         3,487

                                                                      


Total assets                                         35,630



Accounts payable


Deferred revenue


Deferred revenue - extended plans


Other operating liabilities                      3,652

 

Debt

                                                                      


Total liabilities            



Shareholders' equity

 

                                                                      


Total liabilities plus equity                 35,630





Cash flow statement    FY ended February 1, 2019 (in $ million)


Net income


Depreciation and amortization                


Changes in:


           Inventory


           Accounts payable


           Deferred revenue


           Deferred revenue - ext. plans

                                                                     


Cash from operations                           




Capital expenditure                            (1,200)


Change in short-term investments

 

                                                                      


Cash for investments                           




Net borrowings


Dividends


                                                                      


Cash used by financing



Net increase in cash




Lowe's Annual Report: http://phx.corporate-ir.net/phoenix.zhtml?c=95223&p=irol-reportsannual


Screen Shot 2018-04-30 at 9.33.31 PM.png


Screen Shot 2018-04-30 at 9.34.05 PM.png

Screen Shot 2018-04-30 at 9.45.54 PM.png


Screen Shot 2018-04-30 at 9.46.44 PM.png


Notes to consolidated financial statements from page 41-68 in the annual report

Screen Shot 2018-04-30 at 9.33.31 PM.png

Screen Shot 2018-04-30 at 9.34.05 PM.png

Screen Shot 2018-04-30 at 9.45.54 PM.png

Screen Shot 2018-04-30 at 9.46.44 PM.png

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question