The Louisiana Grill The Louisiana Grill (TLG) is a restaurant in Toronto. TLG is a regional...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Louisiana Grill The Louisiana Grill (TLG) is a restaurant in Toronto. TLG is a regional restaurant created and operated by Alex Ven- tresca, a former football player from New Orleans. The company was established in 2016 and has experienced steady revenue growth since inception. The restaurant's success can be attributed to its variety of dishes. Currently, there is only one restaurant, which is located in downtown Toronto. Alex is looking to expand the busi- ness by opening another restaurant in Mississauga, Ontario. Alex estimates that it will cost upward of $1 million to open a new location. Alex has approached Diane Drapeau, a managing partner at a venture capital firm, about the potential opportunity. Alex has proposed two alternatives to finance the new restaurant: 1. Extend credit to the business: Lend TLG $1 million in debt financing. The bond would be secured by the building and equipment purchased with the funds. Alex would like the interest to accrue at 5% per annum. with the loan repayable with blended monthly payments over a five-year term. In exchange for the low interest rate, the bond will be convertible in common shares at the rate of nine common shares per $1,000. 2. Purchase an ownership interest: Purchase 10,000 shares in the business (50% interest). The funds will be used to start up the new location. Depending on the purchase price, any deficiency in the funds required will be obtained through traditional bank financing. Of course, Alex is aware of the fact that Diane can choose neither of the options and walk away from the opportunity. In order to help make a decision, Alex has provided Diane with TLG's historical income statements and statements of financial position since inception (Exhibit I). In addition, Diane had a long discussion with Alex. (Notes from the meeting are in Exhibit II.) Diane has asked you, a newly hired junior analyst, to prepare a preliminary report that provides a recommended course of action. Your report should be based on a thorough analysis of TLG's historical financial performance. As it is one of your first assignments, Diane reminds you that a well-prepared report of this nature should include, at minimum, the following: • The preparation and analysis of the statement of cash flows for the five-year period • An analysis of financial ratios and common-sized financial statements • A preliminary valuation of the common shares (note that a common share earnings multiple for similar franchise restaurants ranges from 4 to 6 times normalized net income) • Based on the estimated share value, the value of the conversion feature over the life of the bond . • A comparison of the rate of return on the equity versus debt investment. . Required Prepare the report for Diane. For simplicity, ignore any financial reporting issues related to the bifurcation of the debt and equity components of the convertible bond. Exhibit I Financial Statements Assets Current assets Cash and cash equivalents Accounts receivable Inventory Prepaid expenses Total current assets Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment Total fixed assets Total assets Liabilities Current liabilities Bank indebtedness Deferred revenue Payables and accruals Income taxes payable Total current liabilities Long-term debt Long-term debt Total liabilities Shareholders' equity Capital stock (10,000 shares issued) Retained earnings Total shareholders' equity Total liabilities and shareholders' equity The Louisiana GRILL Statements of Financial Position for the Year Ended December 31 2016 $0 71,584 107,664 20,419 $ 199,667 $ 165,000 618,213 46,750 94,500 233,750 1,158,213 $1,357,878 $ 100,900 186,789 154,631 17,071 $ 459,391 860,204 $1,319,595 $ 10,000 28,283 38,283 $1,357,878 2017 $ 0 110,272 129,680 17,414 $ 257,366 $ 165,000 556,391 32,725 75,600 163,625 993,341 $1,250,707 $ 175,000 190,949 97,325 15,706 $ 478,980 710,623 $1,189,603 $ 10,000 51,105 61,105 $1,250,707 $ 2018 53,297 67,042 76,408 11,558 $ 208,305 $ 165,000 500,752 22,908 60,480 114,538 863,678 $1,071,983 $0 202,075 122,885 35,070 $360,030 550,570 $910,600 $ 10,000 151,383 161,383 $1,071,983 2019 $ 76,969 91,175 114,630 16,240 $ 299,014 $ 165,000 450,677 16,035 48,384 80,176 760,272 $1,059,286 SO 205,601 176,544 35,289 $ 417,434 379,315 $ 796,749 $ 10,000 252,537 262,537 $1,059,286 28% 2020 $ 199,051 122,647 139,310 26,387 $ 487,395 $ 165,000 405,609 11,225 38,707 56,123 676,664 $1,164,059 $0 219,276 177,636 69,708 $ 466,620 196,071 $662,691 $ 10,000 491,368 501,368 $1,164,059 Exhibit I Financial Statements (Continued) Sales Cost of sales Gross profit Expenses Administrative Advertising Depreciation and amortization Computer Credit card Bad debts Equipment rental Freight Insurance Interest and bank charges Interest on long-term debt Janitorial supplies Office and restaurant supplies Professional fees Repairs and maintenance Royalty fees Taxes and licences Telephone Travel Utilities Wages and benefits Other income Earnings before income taxes Provision for income taxes Net income The Louisiana GRILL Statements of Income for the Year Ended December 31 2016 $3,579,208 2,290,693 $1,288,515 $ 209,117 127,368 92,538 3,074 53,688 716 25,269 16,035 13,113 5,021 63,556 40,425 144,962 3,909 74,152 125,272 1,682 9,338 10,319 92,058 95,000 $1,206,612 3,450 85,354 17,071 68,283 2017 $3,675,730 2,315,710 $1,360,020 $ 214,608 127,083 164,871 5,464 55,136 0 12,271 16,210 10,022 4,248 53,770 48,373 132,242 4,186 75,952 128,651 1,682 9,919 8,031 115,562 95,000 $1,283,281 1,788 78,528 15,706 62,822 2018 $3,943,656 2,464,785 $1,478,871 $ 293,408 131,906 129,664 6,944 59,155 2,011 1,456 17,253 12,300 3,421 43,299 33,565 133,784 4,299 48,455 138,028 1,682 10,248 6,475 135,738 95,000 $1,308,091 4,569 175,349 35,070 140,279 2019 $3,964,108 2,497,388 $1,466,720 $ 302,173 155,140 103,405 4,687 59,462 0 1,726 17,482 13,079 2,536 32,095 43,483 124,079 4,683 49,564 138,744 1,682 10,239 3,957 129,403 95,000 $1,292,619 2,341 176,443 35,289 141,154 2020 $4,229,192 2,579,807 $1,649,385 $ 318,119 148,005 83,608 6,844 63,438 613 2,206 18,059 13,855 1,588 20,108 39,084 129,500 4,481 47,560 148,022 1,682 10,195 9,113 145,347 95,000 $1,306,427 5,580 348,538 69,708 278,830 Retained earnings, beginning Net income Dividend Retained earnings, end 0 68,283 40,000 $ 28,283 28,283 62,822 40,000 $ 51,105 51,105 140,279 40,000 $ 151,383 151,383 141,154 40,000 $ 252,537 252,537 278,830 40,000 $ 491,368 Exhibit II Notes from the Meeting with Alex Historical Financial Results - Toronto Operations The menu of dishes was created by a celebrity chef, who regularly visits the restaurant. The chef is paid a royalty fee of 3.5% of gross revenue. • The original cost of the current assets are as follows: . Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment $165,000 650,750 55,000 105,000 275,000 The capital assets are depreciated in the same manner as their capital cost allowance (CCA). The following CCA rates are used: building, 10%; computer equipment, The Louisiana Grill 30%; furniture, fixtures, and equipment, 20%; and kitchen equipment, 30%. • Deferred revenue represents the value of gift cards sold, but not yet redeemed. • The company initially obtained a $1-million loan, which was repaid with blended payments over a five-year period, with interest of 7%. 41 • Alex has been paying himself an annual dividend of $40,000. He would like this dividend to continue into the future. In addition, Alex draws an annual salary of $95,000, which reflects the fair market value of the services he provides. Future Financial Results - Mississauga Operations . • The Mississauga location is expected to generate the same revenues, and net income, as the Toronto operation. The Louisiana Grill The Louisiana Grill (TLG) is a restaurant in Toronto. TLG is a regional restaurant created and operated by Alex Ven- tresca, a former football player from New Orleans. The company was established in 2016 and has experienced steady revenue growth since inception. The restaurant's success can be attributed to its variety of dishes. Currently, there is only one restaurant, which is located in downtown Toronto. Alex is looking to expand the busi- ness by opening another restaurant in Mississauga, Ontario. Alex estimates that it will cost upward of $1 million to open a new location. Alex has approached Diane Drapeau, a managing partner at a venture capital firm, about the potential opportunity. Alex has proposed two alternatives to finance the new restaurant: 1. Extend credit to the business: Lend TLG $1 million in debt financing. The bond would be secured by the building and equipment purchased with the funds. Alex would like the interest to accrue at 5% per annum. with the loan repayable with blended monthly payments over a five-year term. In exchange for the low interest rate, the bond will be convertible in common shares at the rate of nine common shares per $1,000. 2. Purchase an ownership interest: Purchase 10,000 shares in the business (50% interest). The funds will be used to start up the new location. Depending on the purchase price, any deficiency in the funds required will be obtained through traditional bank financing. Of course, Alex is aware of the fact that Diane can choose neither of the options and walk away from the opportunity. In order to help make a decision, Alex has provided Diane with TLG's historical income statements and statements of financial position since inception (Exhibit I). In addition, Diane had a long discussion with Alex. (Notes from the meeting are in Exhibit II.) Diane has asked you, a newly hired junior analyst, to prepare a preliminary report that provides a recommended course of action. Your report should be based on a thorough analysis of TLG's historical financial performance. As it is one of your first assignments, Diane reminds you that a well-prepared report of this nature should include, at minimum, the following: • The preparation and analysis of the statement of cash flows for the five-year period • An analysis of financial ratios and common-sized financial statements • A preliminary valuation of the common shares (note that a common share earnings multiple for similar franchise restaurants ranges from 4 to 6 times normalized net income) • Based on the estimated share value, the value of the conversion feature over the life of the bond . • A comparison of the rate of return on the equity versus debt investment. . Required Prepare the report for Diane. For simplicity, ignore any financial reporting issues related to the bifurcation of the debt and equity components of the convertible bond. Exhibit I Financial Statements Assets Current assets Cash and cash equivalents Accounts receivable Inventory Prepaid expenses Total current assets Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment Total fixed assets Total assets Liabilities Current liabilities Bank indebtedness Deferred revenue Payables and accruals Income taxes payable Total current liabilities Long-term debt Long-term debt Total liabilities Shareholders' equity Capital stock (10,000 shares issued) Retained earnings Total shareholders' equity Total liabilities and shareholders' equity The Louisiana GRILL Statements of Financial Position for the Year Ended December 31 2016 $0 71,584 107,664 20,419 $ 199,667 $ 165,000 618,213 46,750 94,500 233,750 1,158,213 $1,357,878 $ 100,900 186,789 154,631 17,071 $ 459,391 860,204 $1,319,595 $ 10,000 28,283 38,283 $1,357,878 2017 $ 0 110,272 129,680 17,414 $ 257,366 $ 165,000 556,391 32,725 75,600 163,625 993,341 $1,250,707 $ 175,000 190,949 97,325 15,706 $ 478,980 710,623 $1,189,603 $ 10,000 51,105 61,105 $1,250,707 $ 2018 53,297 67,042 76,408 11,558 $ 208,305 $ 165,000 500,752 22,908 60,480 114,538 863,678 $1,071,983 $0 202,075 122,885 35,070 $360,030 550,570 $910,600 $ 10,000 151,383 161,383 $1,071,983 2019 $ 76,969 91,175 114,630 16,240 $ 299,014 $ 165,000 450,677 16,035 48,384 80,176 760,272 $1,059,286 SO 205,601 176,544 35,289 $ 417,434 379,315 $ 796,749 $ 10,000 252,537 262,537 $1,059,286 28% 2020 $ 199,051 122,647 139,310 26,387 $ 487,395 $ 165,000 405,609 11,225 38,707 56,123 676,664 $1,164,059 $0 219,276 177,636 69,708 $ 466,620 196,071 $662,691 $ 10,000 491,368 501,368 $1,164,059 Exhibit I Financial Statements (Continued) Sales Cost of sales Gross profit Expenses Administrative Advertising Depreciation and amortization Computer Credit card Bad debts Equipment rental Freight Insurance Interest and bank charges Interest on long-term debt Janitorial supplies Office and restaurant supplies Professional fees Repairs and maintenance Royalty fees Taxes and licences Telephone Travel Utilities Wages and benefits Other income Earnings before income taxes Provision for income taxes Net income The Louisiana GRILL Statements of Income for the Year Ended December 31 2016 $3,579,208 2,290,693 $1,288,515 $ 209,117 127,368 92,538 3,074 53,688 716 25,269 16,035 13,113 5,021 63,556 40,425 144,962 3,909 74,152 125,272 1,682 9,338 10,319 92,058 95,000 $1,206,612 3,450 85,354 17,071 68,283 2017 $3,675,730 2,315,710 $1,360,020 $ 214,608 127,083 164,871 5,464 55,136 0 12,271 16,210 10,022 4,248 53,770 48,373 132,242 4,186 75,952 128,651 1,682 9,919 8,031 115,562 95,000 $1,283,281 1,788 78,528 15,706 62,822 2018 $3,943,656 2,464,785 $1,478,871 $ 293,408 131,906 129,664 6,944 59,155 2,011 1,456 17,253 12,300 3,421 43,299 33,565 133,784 4,299 48,455 138,028 1,682 10,248 6,475 135,738 95,000 $1,308,091 4,569 175,349 35,070 140,279 2019 $3,964,108 2,497,388 $1,466,720 $ 302,173 155,140 103,405 4,687 59,462 0 1,726 17,482 13,079 2,536 32,095 43,483 124,079 4,683 49,564 138,744 1,682 10,239 3,957 129,403 95,000 $1,292,619 2,341 176,443 35,289 141,154 2020 $4,229,192 2,579,807 $1,649,385 $ 318,119 148,005 83,608 6,844 63,438 613 2,206 18,059 13,855 1,588 20,108 39,084 129,500 4,481 47,560 148,022 1,682 10,195 9,113 145,347 95,000 $1,306,427 5,580 348,538 69,708 278,830 Retained earnings, beginning Net income Dividend Retained earnings, end 0 68,283 40,000 $ 28,283 28,283 62,822 40,000 $ 51,105 51,105 140,279 40,000 $ 151,383 151,383 141,154 40,000 $ 252,537 252,537 278,830 40,000 $ 491,368 Exhibit II Notes from the Meeting with Alex Historical Financial Results - Toronto Operations The menu of dishes was created by a celebrity chef, who regularly visits the restaurant. The chef is paid a royalty fee of 3.5% of gross revenue. • The original cost of the current assets are as follows: . Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment $165,000 650,750 55,000 105,000 275,000 The capital assets are depreciated in the same manner as their capital cost allowance (CCA). The following CCA rates are used: building, 10%; computer equipment, The Louisiana Grill 30%; furniture, fixtures, and equipment, 20%; and kitchen equipment, 30%. • Deferred revenue represents the value of gift cards sold, but not yet redeemed. • The company initially obtained a $1-million loan, which was repaid with blended payments over a five-year period, with interest of 7%. 41 • Alex has been paying himself an annual dividend of $40,000. He would like this dividend to continue into the future. In addition, Alex draws an annual salary of $95,000, which reflects the fair market value of the services he provides. Future Financial Results - Mississauga Operations . • The Mississauga location is expected to generate the same revenues, and net income, as the Toronto operation. The Louisiana Grill The Louisiana Grill (TLG) is a restaurant in Toronto. TLG is a regional restaurant created and operated by Alex Ven- tresca, a former football player from New Orleans. The company was established in 2016 and has experienced steady revenue growth since inception. The restaurant's success can be attributed to its variety of dishes. Currently, there is only one restaurant, which is located in downtown Toronto. Alex is looking to expand the busi- ness by opening another restaurant in Mississauga, Ontario. Alex estimates that it will cost upward of $1 million to open a new location. Alex has approached Diane Drapeau, a managing partner at a venture capital firm, about the potential opportunity. Alex has proposed two alternatives to finance the new restaurant: 1. Extend credit to the business: Lend TLG $1 million in debt financing. The bond would be secured by the building and equipment purchased with the funds. Alex would like the interest to accrue at 5% per annum. with the loan repayable with blended monthly payments over a five-year term. In exchange for the low interest rate, the bond will be convertible in common shares at the rate of nine common shares per $1,000. 2. Purchase an ownership interest: Purchase 10,000 shares in the business (50% interest). The funds will be used to start up the new location. Depending on the purchase price, any deficiency in the funds required will be obtained through traditional bank financing. Of course, Alex is aware of the fact that Diane can choose neither of the options and walk away from the opportunity. In order to help make a decision, Alex has provided Diane with TLG's historical income statements and statements of financial position since inception (Exhibit I). In addition, Diane had a long discussion with Alex. (Notes from the meeting are in Exhibit II.) Diane has asked you, a newly hired junior analyst, to prepare a preliminary report that provides a recommended course of action. Your report should be based on a thorough analysis of TLG's historical financial performance. As it is one of your first assignments, Diane reminds you that a well-prepared report of this nature should include, at minimum, the following: • The preparation and analysis of the statement of cash flows for the five-year period • An analysis of financial ratios and common-sized financial statements • A preliminary valuation of the common shares (note that a common share earnings multiple for similar franchise restaurants ranges from 4 to 6 times normalized net income) • Based on the estimated share value, the value of the conversion feature over the life of the bond . • A comparison of the rate of return on the equity versus debt investment. . Required Prepare the report for Diane. For simplicity, ignore any financial reporting issues related to the bifurcation of the debt and equity components of the convertible bond. Exhibit I Financial Statements Assets Current assets Cash and cash equivalents Accounts receivable Inventory Prepaid expenses Total current assets Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment Total fixed assets Total assets Liabilities Current liabilities Bank indebtedness Deferred revenue Payables and accruals Income taxes payable Total current liabilities Long-term debt Long-term debt Total liabilities Shareholders' equity Capital stock (10,000 shares issued) Retained earnings Total shareholders' equity Total liabilities and shareholders' equity The Louisiana GRILL Statements of Financial Position for the Year Ended December 31 2016 $0 71,584 107,664 20,419 $ 199,667 $ 165,000 618,213 46,750 94,500 233,750 1,158,213 $1,357,878 $ 100,900 186,789 154,631 17,071 $ 459,391 860,204 $1,319,595 $ 10,000 28,283 38,283 $1,357,878 2017 $ 0 110,272 129,680 17,414 $ 257,366 $ 165,000 556,391 32,725 75,600 163,625 993,341 $1,250,707 $ 175,000 190,949 97,325 15,706 $ 478,980 710,623 $1,189,603 $ 10,000 51,105 61,105 $1,250,707 $ 2018 53,297 67,042 76,408 11,558 $ 208,305 $ 165,000 500,752 22,908 60,480 114,538 863,678 $1,071,983 $0 202,075 122,885 35,070 $360,030 550,570 $910,600 $ 10,000 151,383 161,383 $1,071,983 2019 $ 76,969 91,175 114,630 16,240 $ 299,014 $ 165,000 450,677 16,035 48,384 80,176 760,272 $1,059,286 SO 205,601 176,544 35,289 $ 417,434 379,315 $ 796,749 $ 10,000 252,537 262,537 $1,059,286 28% 2020 $ 199,051 122,647 139,310 26,387 $ 487,395 $ 165,000 405,609 11,225 38,707 56,123 676,664 $1,164,059 $0 219,276 177,636 69,708 $ 466,620 196,071 $662,691 $ 10,000 491,368 501,368 $1,164,059 Exhibit I Financial Statements (Continued) Sales Cost of sales Gross profit Expenses Administrative Advertising Depreciation and amortization Computer Credit card Bad debts Equipment rental Freight Insurance Interest and bank charges Interest on long-term debt Janitorial supplies Office and restaurant supplies Professional fees Repairs and maintenance Royalty fees Taxes and licences Telephone Travel Utilities Wages and benefits Other income Earnings before income taxes Provision for income taxes Net income The Louisiana GRILL Statements of Income for the Year Ended December 31 2016 $3,579,208 2,290,693 $1,288,515 $ 209,117 127,368 92,538 3,074 53,688 716 25,269 16,035 13,113 5,021 63,556 40,425 144,962 3,909 74,152 125,272 1,682 9,338 10,319 92,058 95,000 $1,206,612 3,450 85,354 17,071 68,283 2017 $3,675,730 2,315,710 $1,360,020 $ 214,608 127,083 164,871 5,464 55,136 0 12,271 16,210 10,022 4,248 53,770 48,373 132,242 4,186 75,952 128,651 1,682 9,919 8,031 115,562 95,000 $1,283,281 1,788 78,528 15,706 62,822 2018 $3,943,656 2,464,785 $1,478,871 $ 293,408 131,906 129,664 6,944 59,155 2,011 1,456 17,253 12,300 3,421 43,299 33,565 133,784 4,299 48,455 138,028 1,682 10,248 6,475 135,738 95,000 $1,308,091 4,569 175,349 35,070 140,279 2019 $3,964,108 2,497,388 $1,466,720 $ 302,173 155,140 103,405 4,687 59,462 0 1,726 17,482 13,079 2,536 32,095 43,483 124,079 4,683 49,564 138,744 1,682 10,239 3,957 129,403 95,000 $1,292,619 2,341 176,443 35,289 141,154 2020 $4,229,192 2,579,807 $1,649,385 $ 318,119 148,005 83,608 6,844 63,438 613 2,206 18,059 13,855 1,588 20,108 39,084 129,500 4,481 47,560 148,022 1,682 10,195 9,113 145,347 95,000 $1,306,427 5,580 348,538 69,708 278,830 Retained earnings, beginning Net income Dividend Retained earnings, end 0 68,283 40,000 $ 28,283 28,283 62,822 40,000 $ 51,105 51,105 140,279 40,000 $ 151,383 151,383 141,154 40,000 $ 252,537 252,537 278,830 40,000 $ 491,368 Exhibit II Notes from the Meeting with Alex Historical Financial Results - Toronto Operations The menu of dishes was created by a celebrity chef, who regularly visits the restaurant. The chef is paid a royalty fee of 3.5% of gross revenue. • The original cost of the current assets are as follows: . Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment $165,000 650,750 55,000 105,000 275,000 The capital assets are depreciated in the same manner as their capital cost allowance (CCA). The following CCA rates are used: building, 10%; computer equipment, The Louisiana Grill 30%; furniture, fixtures, and equipment, 20%; and kitchen equipment, 30%. • Deferred revenue represents the value of gift cards sold, but not yet redeemed. • The company initially obtained a $1-million loan, which was repaid with blended payments over a five-year period, with interest of 7%. 41 • Alex has been paying himself an annual dividend of $40,000. He would like this dividend to continue into the future. In addition, Alex draws an annual salary of $95,000, which reflects the fair market value of the services he provides. Future Financial Results - Mississauga Operations . • The Mississauga location is expected to generate the same revenues, and net income, as the Toronto operation. The Louisiana Grill The Louisiana Grill (TLG) is a restaurant in Toronto. TLG is a regional restaurant created and operated by Alex Ven- tresca, a former football player from New Orleans. The company was established in 2016 and has experienced steady revenue growth since inception. The restaurant's success can be attributed to its variety of dishes. Currently, there is only one restaurant, which is located in downtown Toronto. Alex is looking to expand the busi- ness by opening another restaurant in Mississauga, Ontario. Alex estimates that it will cost upward of $1 million to open a new location. Alex has approached Diane Drapeau, a managing partner at a venture capital firm, about the potential opportunity. Alex has proposed two alternatives to finance the new restaurant: 1. Extend credit to the business: Lend TLG $1 million in debt financing. The bond would be secured by the building and equipment purchased with the funds. Alex would like the interest to accrue at 5% per annum. with the loan repayable with blended monthly payments over a five-year term. In exchange for the low interest rate, the bond will be convertible in common shares at the rate of nine common shares per $1,000. 2. Purchase an ownership interest: Purchase 10,000 shares in the business (50% interest). The funds will be used to start up the new location. Depending on the purchase price, any deficiency in the funds required will be obtained through traditional bank financing. Of course, Alex is aware of the fact that Diane can choose neither of the options and walk away from the opportunity. In order to help make a decision, Alex has provided Diane with TLG's historical income statements and statements of financial position since inception (Exhibit I). In addition, Diane had a long discussion with Alex. (Notes from the meeting are in Exhibit II.) Diane has asked you, a newly hired junior analyst, to prepare a preliminary report that provides a recommended course of action. Your report should be based on a thorough analysis of TLG's historical financial performance. As it is one of your first assignments, Diane reminds you that a well-prepared report of this nature should include, at minimum, the following: • The preparation and analysis of the statement of cash flows for the five-year period • An analysis of financial ratios and common-sized financial statements • A preliminary valuation of the common shares (note that a common share earnings multiple for similar franchise restaurants ranges from 4 to 6 times normalized net income) • Based on the estimated share value, the value of the conversion feature over the life of the bond . • A comparison of the rate of return on the equity versus debt investment. . Required Prepare the report for Diane. For simplicity, ignore any financial reporting issues related to the bifurcation of the debt and equity components of the convertible bond. Exhibit I Financial Statements Assets Current assets Cash and cash equivalents Accounts receivable Inventory Prepaid expenses Total current assets Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment Total fixed assets Total assets Liabilities Current liabilities Bank indebtedness Deferred revenue Payables and accruals Income taxes payable Total current liabilities Long-term debt Long-term debt Total liabilities Shareholders' equity Capital stock (10,000 shares issued) Retained earnings Total shareholders' equity Total liabilities and shareholders' equity The Louisiana GRILL Statements of Financial Position for the Year Ended December 31 2016 $0 71,584 107,664 20,419 $ 199,667 $ 165,000 618,213 46,750 94,500 233,750 1,158,213 $1,357,878 $ 100,900 186,789 154,631 17,071 $ 459,391 860,204 $1,319,595 $ 10,000 28,283 38,283 $1,357,878 2017 $ 0 110,272 129,680 17,414 $ 257,366 $ 165,000 556,391 32,725 75,600 163,625 993,341 $1,250,707 $ 175,000 190,949 97,325 15,706 $ 478,980 710,623 $1,189,603 $ 10,000 51,105 61,105 $1,250,707 $ 2018 53,297 67,042 76,408 11,558 $ 208,305 $ 165,000 500,752 22,908 60,480 114,538 863,678 $1,071,983 $0 202,075 122,885 35,070 $360,030 550,570 $910,600 $ 10,000 151,383 161,383 $1,071,983 2019 $ 76,969 91,175 114,630 16,240 $ 299,014 $ 165,000 450,677 16,035 48,384 80,176 760,272 $1,059,286 SO 205,601 176,544 35,289 $ 417,434 379,315 $ 796,749 $ 10,000 252,537 262,537 $1,059,286 28% 2020 $ 199,051 122,647 139,310 26,387 $ 487,395 $ 165,000 405,609 11,225 38,707 56,123 676,664 $1,164,059 $0 219,276 177,636 69,708 $ 466,620 196,071 $662,691 $ 10,000 491,368 501,368 $1,164,059 Exhibit I Financial Statements (Continued) Sales Cost of sales Gross profit Expenses Administrative Advertising Depreciation and amortization Computer Credit card Bad debts Equipment rental Freight Insurance Interest and bank charges Interest on long-term debt Janitorial supplies Office and restaurant supplies Professional fees Repairs and maintenance Royalty fees Taxes and licences Telephone Travel Utilities Wages and benefits Other income Earnings before income taxes Provision for income taxes Net income The Louisiana GRILL Statements of Income for the Year Ended December 31 2016 $3,579,208 2,290,693 $1,288,515 $ 209,117 127,368 92,538 3,074 53,688 716 25,269 16,035 13,113 5,021 63,556 40,425 144,962 3,909 74,152 125,272 1,682 9,338 10,319 92,058 95,000 $1,206,612 3,450 85,354 17,071 68,283 2017 $3,675,730 2,315,710 $1,360,020 $ 214,608 127,083 164,871 5,464 55,136 0 12,271 16,210 10,022 4,248 53,770 48,373 132,242 4,186 75,952 128,651 1,682 9,919 8,031 115,562 95,000 $1,283,281 1,788 78,528 15,706 62,822 2018 $3,943,656 2,464,785 $1,478,871 $ 293,408 131,906 129,664 6,944 59,155 2,011 1,456 17,253 12,300 3,421 43,299 33,565 133,784 4,299 48,455 138,028 1,682 10,248 6,475 135,738 95,000 $1,308,091 4,569 175,349 35,070 140,279 2019 $3,964,108 2,497,388 $1,466,720 $ 302,173 155,140 103,405 4,687 59,462 0 1,726 17,482 13,079 2,536 32,095 43,483 124,079 4,683 49,564 138,744 1,682 10,239 3,957 129,403 95,000 $1,292,619 2,341 176,443 35,289 141,154 2020 $4,229,192 2,579,807 $1,649,385 $ 318,119 148,005 83,608 6,844 63,438 613 2,206 18,059 13,855 1,588 20,108 39,084 129,500 4,481 47,560 148,022 1,682 10,195 9,113 145,347 95,000 $1,306,427 5,580 348,538 69,708 278,830 Retained earnings, beginning Net income Dividend Retained earnings, end 0 68,283 40,000 $ 28,283 28,283 62,822 40,000 $ 51,105 51,105 140,279 40,000 $ 151,383 151,383 141,154 40,000 $ 252,537 252,537 278,830 40,000 $ 491,368 Exhibit II Notes from the Meeting with Alex Historical Financial Results - Toronto Operations The menu of dishes was created by a celebrity chef, who regularly visits the restaurant. The chef is paid a royalty fee of 3.5% of gross revenue. • The original cost of the current assets are as follows: . Fixed assets (net) Land Building Computer and equipment Furniture, fixtures, and equipment Kitchen equipment $165,000 650,750 55,000 105,000 275,000 The capital assets are depreciated in the same manner as their capital cost allowance (CCA). The following CCA rates are used: building, 10%; computer equipment, The Louisiana Grill 30%; furniture, fixtures, and equipment, 20%; and kitchen equipment, 30%. • Deferred revenue represents the value of gift cards sold, but not yet redeemed. • The company initially obtained a $1-million loan, which was repaid with blended payments over a five-year period, with interest of 7%. 41 • Alex has been paying himself an annual dividend of $40,000. He would like this dividend to continue into the future. In addition, Alex draws an annual salary of $95,000, which reflects the fair market value of the services he provides. Future Financial Results - Mississauga Operations . • The Mississauga location is expected to generate the same revenues, and net income, as the Toronto operation.
Expert Answer:
Answer rating: 100% (QA)
ANSWER Financial Reporting includes the disclosure of economic facts to the numerous stakeholders ap... View the full answer
Related Book For
Accounting Tools for business decision making
ISBN: 978-0470095461
4th Edition
Authors: kimmel, weygandt, kieso
Posted Date:
Students also viewed these accounting questions
-
Prepare a report for Diane. For simplicity, ignore any financial reporting issues related to the (bifurication) splitting up/division of the debt and equity components of the convertible bond....
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
IST 8100 Supplemental Cases Inside Microsoft During last fall's United Way campaign at Microsoft, two vice-presidents made a wager on whose division would generate the most contributions. The loser,...
-
While emptying a wheelbarrow, a gardener exerts on each handle AB a force P directed along line CD. Knowing that P must have a 30-lb horizontal component, determine (a) The magnitude of the force P,...
-
Tiny College wants to keep track of the history of all administrative appointments (date of appointment and date of termination). The Tiny College chancellor may want to know how many deans worked in...
-
What minimum amount of hydrogen gas, in grams, is required to completely hydrogenate 15.5 kg of 2-butene?
-
What is the major advantage of snowball sampling?
-
On July 1, 2013, Ross-Livermore Industries issued nine-month notes in the amount of $400 million. Interest is payable at maturity. Required: Determine the amount of interest expense that should be...
-
You will deposit $2,000 at the end of each of next 3 years. If the interest rate is 10% (annual compounding), how much will you have accumulated in 26 years?
-
A solar collector design consists of several parallel tubes each enclosed concentrically in an outer tube which is transparent to solar radiation. The tubes are thin walled with diameter of the inner...
-
Discussion Questions for The World of the Worker Chapter 5 - "The Depression, the New Deal, and the New Industrial Unions" 1.) How did the Great Depression affect American workers? 2.) With what...
-
The following data are available: Date year 2 - - - Concepts Units Unit Cost June 1 Begining inventory 1 0 0 2 9 , 5 June 4 Purchase 2 5 0 3 3 June 1 2 Sales 1 2 0 June 1 8 Purchase 4 0 0 3 0 June 2...
-
What is the main purpose of the Organization of the Petroleum Exporting Countries (OPEC)? A. Regulating international trade B. Promoting renewable energy sources C. Controlling the production and...
-
Brendan Jones, CFP, is a financial planning and investment manager in the Washington, D.C. area.Jones has two new clients, Jeffrey and Mary Lewinsky, a married couple who live relatively close to the...
-
Accounts appearing in the December 31 trial balance of Marmara Inc. are listed below: Accounts Payable Capital Stock Accounts Receivable Bank Loan Dividends Rent Expense Salaries Expense Depreciation...
-
A company produces three different products 1,2,3. Unit labor hours needed to produce one unit of product, fixed cost of producing each product, and unit profits are given below. Labor hours...
-
A 7.8 kg mass moves along a frictionless track in a circular loop of radius 6.0 m. At the top of the loop, the mass is inverted and barely completes the loop. What normal force acts on the mass when...
-
The liquidliquid extractor in Figure 8.1 operates at 100F and a nominal pressure of 15 psia. For the feed and solvent flows shown, determine the number of equilibrium stages to extract 99.5% of the...
-
Deleon Inc. is preparing its annual budgets for the year ending December 31, 2013. Accounting assistants furnish the data shown below. An accounting assistant has prepared the detailed manufacturing...
-
During 2009, Federal Express reported the following information (in millions): net sales of $35,497 and net income of $98. Its balance sheet also showed total assets at the beginning of the year of...
-
The July 28, 2007, issue of the Wall Street Journal includes an article by Kathryn Kranhold entitled GEs Accounting Draws Fresh Focus on News of Improper Sales Bookings. Instructions Read the article...
-
The average tax rate on a corporate income of \(\$ 87,000\) is closest to which of the following? a. 15 percent b. 20.5 percent c. 25 percent d. 34 percent
-
True or False: If investment capital is borrowed, the income tax rate equals \(40 \%\), the after-tax MARR is \(12 \%\), and the loan rate is \(10 \%\), then it is best to repay the loan using Plan 4.
-
Calculate the corporate income tax for each of the following corporate taxable incomes. For each, determine the effective (average) tax rate and the marginal tax rate. a. $22,000 b. $93,000 c....
Study smarter with the SolutionInn App