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. Either individually or in a group, think about the ethical implications of social loafing in a self-managed team. 2. Do managers have an ethical obligation to step in when they are aware of social...
-
A skier of mass 65.0 kg is pulled up a snow-covered slope at constant speed by a tow rope that is parallel to the ground. The ground slopes upward at a constant angle of 26.0 above the horizontal,...
-
The magnitude of the magnetic field in Figure P29.40 changes with time, and the magnitude of the accompanying electric field inside the magnetic field is given by \(E(r, t)=3 C r t^{2}\), where \(C\)...
-
Anne Elizabeth Corporation is engaged in the business of making toys. A high percentage of its products are sold to consumers during November and December. Therefore, retailers need to have the toys...
-
31 The number of protons, electrons and neutrons in aluminium ion Al+ is Protons A. 27 B. 13 C. ABCD 32 32. D. 13 10 Electron 27 neutrons 14 14 14 10 14 17 14 The formula of the compound formed...
-
Allison, age 40, earns $81,915 annually; her wage replacement ratio has been determined to be 73%. She expects inflation will average 3% over her entire life expectancy. She expects to work until 67...
-
The table below presents the production per capita, and the corresponding price level in two simplified economies, rich and poor. The market exchange rate is 1 unit of the rich country's currency =...
-
How RBR solved its global manufacturing challenge to provide its precision-instrumented, high-mix, low-volume build-to-order products. Determine how each of the 10 OM strategic decisions apply to RBR...
-
State True / False the following statements and justify with ONE - line / paragraph statement or appropriate examples A general purpose computer can be used for a specific purpose by using software...
-
[3) A sample of size n = 100 produced the sample mean of m = 17. Assuming the sample standard deviation = 4, compute a 95% confidence interval for the mean m. [4] Assuming the population standard...
-
Q1. Let A, B, and C be three events such that: P(A)=0.5, P(B)=0.4, P(CA)=0.6, P(CA)=0.2, and P(AUB)=0.9. Then (a) P(C)= (A) 0.1 (B) 0.6 (C) 0.8 (D) 0.2 (E) 0.5 (b) P(BA)= (A) 0.0 (B) 0.9 (C) 0.1 (D)...
-
You have been provided the following two statements, Statement of Financial Position (SOFP), Statement of Comprehensive Income (SOCI) and some additional information of MRL for the year ended 31...
-
When asked for the router password, Brad gave the information to the telephone caller. When asked for the router password, Brad gave the information to the telephone caller. (True/False)
-
(a) Water flows through the nozzle of a garden hose. Find an expression for m in terms of line pressure P 1 , ambient pressure P 2 , inside hose diameter D 1 , and nozzle outlet diameter D 2 . Assume...
-
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...
-
Principles for Responsible Management Education (PRME) is a not-for-profit entity. It engages business schools to ensure they provide future leaders with the skills needed to balance economic and...
-
You are setting up a chatbot agency to service marketing, sales and customer services teams. Discuss the advantages and disadvantages of setting up the business as a sole trader or company and the...
-
Entities are expected to perform in environmental, governance and social areas as well as profit (unless a not-for-profit entity). List some key performance indicators applicable to each sphere.
Study smarter with the SolutionInn App