Mr. Tiwari a young and upcoming professional decided to open a franchised supermarket after completing his...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mr. Tiwari a young and upcoming professional decided to open a franchised supermarket after completing his various education. After 30 years of being in operation, he became the owner and CEO of Lowcost Supermarket Inc. (Lowcost), a franchisee of a national food retailer. Lowcost owns a modern 3,500-square-metre superstore that generated more than $20 million in sales in the last fiscal year. Please see Appendix I contains excerpts from Lowcost's financial statements. Although he is still active and does not plan to retire, Mr. Tiwari has a daughter, Tejal, who is aspiring to follow in her father's footsteps. Moreover, new competitors are coming into the market, and Mr. Tiwari does not want to be left behind. Hence, he is currently considering two expansion options that would allow his daughter to prove herself: 1. Expand the existing store to make it a "destination" outlet that reaches a wider customer base. 2. Buy another store, Other Store Inc. (Other Store), in a neighbouring suburb that would be managed solely by Tejal. Today is February 2, 2020, and Mr. Tiwari has retained you, CPA, to assess the two options from both a quantitative and qualitative perspective. He has provided you with the critical assumptions underlying the expansion project (Appendix II) and the financial information on Other Store (Appendix III). He would like you to advise him on which option is the most attractive, in terms of both expected returns and risk levels. He would also like you to calculate and justify an appropriate discount rate that you will use for your quantitative analysis and to assess the appropriateness of the financing alternatives being proposed for each option. Appendix I Excerpts from Lowcost's financial statements Income Statement 12 months ended December 31 (in thousands of dollars) 2019 2018 2017 Net sales $20,260 $19,500 $18,750 Cost of goods sold 15,500 14,500 13,750 Gross profit 4,760 5,000 5,000 Operating expenses 3,250 3,100 3,000 EBITDA 1,510 1,900 2,000 Depreciation and amortization 450 500 650 Interest expense 100 100 100 Income before tax 960 1,300 1,250 Income tax 260 400 375 Profit/loss $700 $900 $875 Cash Flow Statement 12 months ended December 31 (in thousands of dollars) 2019 2018 2017 Operations: Cash flow from operations $1,150 $1,400 $1,525 Changes in non-cash working capital (75) (50) (125) Total cash from operating activities 1,075 1,350 1,400 Total cash from investing activities (250) (300) (250) Total cash from financing activities (100) (100) (100) Dividends (475) (850) (1,400) Change in cash 250 100 (350) Cash at beginning of period 100 350 Cash at end of period $350 $100 $0 Appendix II Critical assumptions underlying the expansion project The expansion project entails reconfiguring and updating the existing store and adding 2,000 square metres to its floor plan. The project would be complete by the end of 2020, and store operations would continue throughout the construction. Key estimates supplied by architects (in thousands of dollars) are as follows: Estimated cost of project (materials, labour, supplies, taxes) $8,000 Other key estimates provided by consultants (dollar amounts in thousands): Additional sales revenues in first full year of operations for new store (2021) $5,000 Annual sales growth rate for the four years following the first full year of expanded and reconfigured operations (2022-2025) applicable to total sales revenue* 10% Annual sales growth rate without expansion and reconfiguration 4% EBITDA margin (expected to remain at that level for the foreseeable future) 7,5% Expansion investment to be depreciated over 16 years on a straight-line basis (also for tax purposes) Income tax rate 30% Lowcost's bank has tentatively committed to providing a bridge loan convertible into a 20-year mortgage bearing interest at 6%, for up to $6,000. No repayment is due for the first five years. All the firm's long-term assets will be pledged as collateral to the mortgage, and Mr. Tiwari will personally guarantee the loan. $6,000 Currently, Lowcost has long-term assets with a book value of $5,000. Lowcost has a line of credit with $1.0 million of remaining borrowing capacity carrying an interest rate of prime plus 200 basis points (current prime rate is 5%). This credit line is unsecured. *Beyond 2025, sales growth is assumed to be approximately 4%. Future capital expenditures and investment in net working capital will be minimal. Mr. Tiwari expects his firm's return on equity to be 15% (2019 rate) and its long-term target capital structure to be 25% debt and 75% equity as at the end of 2019 (currently debt of $1.5 million and equity of $4.5 million). Mr. Tiwari will inject $1.0 million in the firm (in the form of equity) to get the project going as soon as possible. He believes that the proper time horizon for assessing the project is 16 years because he estimates that the store will need to be refurnished at that time; however, the cost will be much less than the original $8.0 million investment for the full expansion nstruction of the new floorplan. Appendix III Other Store Inc. Financial highlights Fiscal year ended December 31 (in thousands of dollars) 2019 2018 2017 Sales $10,000 $10,250 $10,500 Gross margin 2,000 2,100 2,200 Operating expenses 1,300 1,250 1,200 Depreciation 200 250 300 Earnings before income taxes 500 600 700 Income taxes 150 230 260 Net earnings $350 $370 $440 Cash from operations $600 $650 $750 Working capital $200 $250 $300 Long-term assets $0 $100 $200 Equity $200 $350 $500 The store occupies a wholly owned building of 2,250 square metres. The firm has no long-term debt. With an aging owner seeking to sell and retire, the firm has underinvested in recent years, paying out a significant portion of its cash flow as dividends. The existing assets are fully depreciated for tax and accounting purposes as at December 31, 2019. To update the store, bring it to the standards of the franchisor, and expand it to around 3,000 square metres, Mr. Tiwari estimates an investment of $4.0 million will be needed, which would be depreciated over 20 years for both tax and accounting purposes. Results for 2020 would be affected negatively by the rebranding, construction, and expansion, with sales going down to $9.0 million. However, annual sales growth of 25% is expected for 2021, 2022, and 2023, stabilizing at the long-term rate of economic growth of 3% afterward. Capital expenditures and investment in net working capital are expected to be minimal over the period. Bank financing terms would be similar to those of the store expansion project, with both stores being pledged. The investment's time horizon is 20 years, at which point the store will need to be updated but at a much lower cost than the original investment. Mr. Tiwari expects the store's EBITDA margin to be around 7.5% once the renovation and expansion is complete by the start of 2021. Food retail stores are typically sold for prices that range between five and seven times EBITDA. The owner is willing to sell the company for $3.3 million. Mr. Tiwari wonders if this price is in line with industry norms. The owner is also willing to finance the purchase, requiring 20% down with the balance due over 10 years in equal instalments. The interest rate would be 12% and would be secured by the underlying store assets and a personal guarantee from Mr. Tiwari. Mr. Tiwari a young and upcoming professional decided to open a franchised supermarket after completing his various education. After 30 years of being in operation, he became the owner and CEO of Lowcost Supermarket Inc. (Lowcost), a franchisee of a national food retailer. Lowcost owns a modern 3,500-square-metre superstore that generated more than $20 million in sales in the last fiscal year. Please see Appendix I contains excerpts from Lowcost's financial statements. Although he is still active and does not plan to retire, Mr. Tiwari has a daughter, Tejal, who is aspiring to follow in her father's footsteps. Moreover, new competitors are coming into the market, and Mr. Tiwari does not want to be left behind. Hence, he is currently considering two expansion options that would allow his daughter to prove herself: 1. Expand the existing store to make it a "destination" outlet that reaches a wider customer base. 2. Buy another store, Other Store Inc. (Other Store), in a neighbouring suburb that would be managed solely by Tejal. Today is February 2, 2020, and Mr. Tiwari has retained you, CPA, to assess the two options from both a quantitative and qualitative perspective. He has provided you with the critical assumptions underlying the expansion project (Appendix II) and the financial information on Other Store (Appendix III). He would like you to advise him on which option is the most attractive, in terms of both expected returns and risk levels. He would also like you to calculate and justify an appropriate discount rate that you will use for your quantitative analysis and to assess the appropriateness of the financing alternatives being proposed for each option. Appendix I Excerpts from Lowcost's financial statements Income Statement 12 months ended December 31 (in thousands of dollars) 2019 2018 2017 Net sales $20,260 $19,500 $18,750 Cost of goods sold 15,500 14,500 13,750 Gross profit 4,760 5,000 5,000 Operating expenses 3,250 3,100 3,000 EBITDA 1,510 1,900 2,000 Depreciation and amortization 450 500 650 Interest expense 100 100 100 Income before tax 960 1,300 1,250 Income tax 260 400 375 Profit/loss $700 $900 $875 Cash Flow Statement 12 months ended December 31 (in thousands of dollars) 2019 2018 2017 Operations: Cash flow from operations $1,150 $1,400 $1,525 Changes in non-cash working capital (75) (50) (125) Total cash from operating activities 1,075 1,350 1,400 Total cash from investing activities (250) (300) (250) Total cash from financing activities (100) (100) (100) Dividends (475) (850) (1,400) Change in cash 250 100 (350) Cash at beginning of period 100 350 Cash at end of period $350 $100 $0 Appendix II Critical assumptions underlying the expansion project The expansion project entails reconfiguring and updating the existing store and adding 2,000 square metres to its floor plan. The project would be complete by the end of 2020, and store operations would continue throughout the construction. Key estimates supplied by architects (in thousands of dollars) are as follows: Estimated cost of project (materials, labour, supplies, taxes) $8,000 Other key estimates provided by consultants (dollar amounts in thousands): Additional sales revenues in first full year of operations for new store (2021) $5,000 Annual sales growth rate for the four years following the first full year of expanded and reconfigured operations (2022-2025) applicable to total sales revenue* 10% Annual sales growth rate without expansion and reconfiguration 4% EBITDA margin (expected to remain at that level for the foreseeable future) 7,5% Expansion investment to be depreciated over 16 years on a straight-line basis (also for tax purposes) Income tax rate 30% Lowcost's bank has tentatively committed to providing a bridge loan convertible into a 20-year mortgage bearing interest at 6%, for up to $6,000. No repayment is due for the first five years. All the firm's long-term assets will be pledged as collateral to the mortgage, and Mr. Tiwari will personally guarantee the loan. $6,000 Currently, Lowcost has long-term assets with a book value of $5,000. Lowcost has a line of credit with $1.0 million of remaining borrowing capacity carrying an interest rate of prime plus 200 basis points (current prime rate is 5%). This credit line is unsecured. *Beyond 2025, sales growth is assumed to be approximately 4%. Future capital expenditures and investment in net working capital will be minimal. Mr. Tiwari expects his firm's return on equity to be 15% (2019 rate) and its long-term target capital structure to be 25% debt and 75% equity as at the end of 2019 (currently debt of $1.5 million and equity of $4.5 million). Mr. Tiwari will inject $1.0 million in the firm (in the form of equity) to get the project going as soon as possible. He believes that the proper time horizon for assessing the project is 16 years because he estimates that the store will need to be refurnished at that time; however, the cost will be much less than the original $8.0 million investment for the full expansion nstruction of the new floorplan. Appendix III Other Store Inc. Financial highlights Fiscal year ended December 31 (in thousands of dollars) 2019 2018 2017 Sales $10,000 $10,250 $10,500 Gross margin 2,000 2,100 2,200 Operating expenses 1,300 1,250 1,200 Depreciation 200 250 300 Earnings before income taxes 500 600 700 Income taxes 150 230 260 Net earnings $350 $370 $440 Cash from operations $600 $650 $750 Working capital $200 $250 $300 Long-term assets $0 $100 $200 Equity $200 $350 $500 The store occupies a wholly owned building of 2,250 square metres. The firm has no long-term debt. With an aging owner seeking to sell and retire, the firm has underinvested in recent years, paying out a significant portion of its cash flow as dividends. The existing assets are fully depreciated for tax and accounting purposes as at December 31, 2019. To update the store, bring it to the standards of the franchisor, and expand it to around 3,000 square metres, Mr. Tiwari estimates an investment of $4.0 million will be needed, which would be depreciated over 20 years for both tax and accounting purposes. Results for 2020 would be affected negatively by the rebranding, construction, and expansion, with sales going down to $9.0 million. However, annual sales growth of 25% is expected for 2021, 2022, and 2023, stabilizing at the long-term rate of economic growth of 3% afterward. Capital expenditures and investment in net working capital are expected to be minimal over the period. Bank financing terms would be similar to those of the store expansion project, with both stores being pledged. The investment's time horizon is 20 years, at which point the store will need to be updated but at a much lower cost than the original investment. Mr. Tiwari expects the store's EBITDA margin to be around 7.5% once the renovation and expansion is complete by the start of 2021. Food retail stores are typically sold for prices that range between five and seven times EBITDA. The owner is willing to sell the company for $3.3 million. Mr. Tiwari wonders if this price is in line with industry norms. The owner is also willing to finance the purchase, requiring 20% down with the balance due over 10 years in equal instalments. The interest rate would be 12% and would be secured by the underlying store assets and a personal guarantee from Mr. Tiwari.
Expert Answer:
Answer rating: 100% (QA)
With Expansion Appendix I Excerpts from Lowcosts financial statements Income Statement 12 months ended December 31 in thousands of dollars 2025 2024 2... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these accounting questions
-
A father pulls his young daughter on a sled with a constant velocity on a level surface a distance of 10 m, as illustrated in Fig. 5.27a. If the total mass of the sled and the girl is 35 kg and the...
-
ABC Ltd is a company engaged in the manufacturing and selling of metal cans .The following data provided below relate to ABC Ltd for the months October and November 2021. Variable Selling Overhead:...
-
Delayla Bouquet France, the French subsidiary of a British company, Delayla Bouquet British has just received 4.4 million of additional investment from its British parent. Part of the investment is a...
-
Several factors can impact the structural soundness of 3D-printed objects, including the struts that connect various pieces. The following data appears in the article Analyzing the Effects of...
-
1. Is the plan constitutional? 2. Is the First Amendment at issue? Explain your answer.
-
Under the insurance contract, were lost profits a foreseeable harm, entitling Lawrence to consequential damages?
-
Tiger Energy has the following information: The lease is subleased to Phil Oil Corporation for $300,000, and Tiger retains an 1/16 ORI. At the date of the sublease, the FMV of the equipment is...
-
Which of the following cases meet the substantively the same governing body criterion? Is this sufficient to indicate that a component unit should be blended in a citys financial statements instead...
-
sis about a mean using the critical value method. . [7 points] [Example: Hypothesis Test (Critical Value)] A computer software vendor claims that a new version of their operating system will crash...
-
Why has Ultra Cables stock price dropped so much recently despite an increase in its revenues and its earnings per share? Ultra Cable Corporation Statement of Cash Flows Current Year $ 100,000 Cash...
-
Wookie Company issues 7%, five-year bonds, on January 1 of this year, with a par value of $99,000 and semiannual interest payment Semiannual Period-End (0) January 1, issuance (1) June 30, first...
-
Prepare the schedule of cost of goods manufactured for Barton Company using the following information for the year ended December 31. Direct materials used Direct labor Factory overhead Work in...
-
Make a pseudocode for accumulator architecture, to solve equation: A+(8*CHD/E) Example: In accumulator you must give all calculations (see last column) Don't use spaces or brackets; All letters mast...
-
Five data entry operators work at the data processing department of the Birmingham Bank. Each day for 30 days, the number of defective records in a sample of 300 records typed by these operators has...
-
Hawkeye Inc. has signed a building contract with a customer. The contract price is $1,800,000, and construction costs are estimated to be $1,200,000. The actual costs and estimated future costs by...
-
4. You attach a mass, M, to a string that is wrapped around a pulley with moment of inertia I and radius R. Then you measure the height of the mass as a function of time as the mass falls, unwinding...
-
QUESTION 4 (8) A project requires an initial investment of R225,000 and is expected to generate the following net cash inflows: Year 1:R95,000 Year 2:R80,000 Year 3:R60,000 Year 4:R55,000 Required:...
-
What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?
-
Palmer made a valid contract with Ames under which Ames was to sell Palmers goods on commission from January 1 to June 30. Ames made satisfactory sales up to May 15 and was then about to close an...
-
McDonalds has an undeviating policy of retaining absolute control over who receives new franchises. McDonalds granted to Copeland a franchise in Omaha, Nebraska. In a separate letter, it also granted...
-
Civil Code 1719, subdivision (a) provides in part that any person who draws a check that is dishonored due to insufficient funds shall be liable to the payee for the amount owing upon the check and...
-
Given the following information, what is WBM Corporation's WACC? Common Stock: 1 million shares outstanding, \($40\) per share, \($1\) par value, beta = 1.3 Bonds: 10,000 bonds outstanding,...
-
Assuming that a firm uses at least some debt, which of the following expressions must be correct? a. Rx(1-T)>R> WACC b. WACC>R>RX (1-T) c. R>WACC>R, x(1-T) d. R,x(1-T)> WACC>R E
-
Suppose a company has five-year, semiannual-coupon bonds carrying an 8 percent coupon rate that are selling for $1,200. What would be the aftertax cost of debt on these bonds if the appropriate tax...
Study smarter with the SolutionInn App