Migatus Enterprise is one of the top retail companies in the Philippines. Mr. Rene Tanasas, its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Migatus Enterprise is one of the top retail companies in the Philippines. Mr. Rene Tanasas, its Chief Executive Officer (CEO), wanted to establish a simple income statement model that can forecast its company's income in the next five (5) years. He wanted the model to do some cost analysis which includes knowing the average, weighted average, and median of the costs for each year. Mr. Tanasas knew that aside from being an auditor, you are also a financial modeler; thus, he approached you to create a simple income statement model of its company. He gave you the following information for the past two (2) years of its operations: Revenues Less: Cost of Goods Sold (COGS) Gross Profit Income Statement Less: General, Selling, and Administrative Expenses Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) Less: Depreciation Expense Interest Earnings Before Taxes (EBT) Less: Taxes Net Income 20X1 P300,000 120,000 180,000 20,000 160,000 12,000 3,500 144,500 43,350 P101,150 20X2 P400,000 275,000 125,000 21,200 103,800 12,000 3,500 88,300 26,490 P61,810 Based on the above data, Mr. Tanasas came up with the following assumptions for the next five (5) years: The sales growth will remain constant. The percentage of COGS against sales is equal to the average percentage of the above COGSS. The general and administrative expenses will be P20,000 per year. The interest will increase by P6,500, and the tax rate will decrease to 20%. The depreciation expense is equal to 4% of sales. The amount of standard total operating expenses of the company per year is 400,000. The company has the following weight for its costs: Cost of Goods Sold, 55%; . o General, Selling, and Administrative Expenses, 20%; 0 Depreciation Expenses, 10%; O Interest Expenses, 5%; and o Taxes, 10% Required: 1. Create a simple income statement model for Migatsu Enterprise using Microsoft (MS) Excel. You may refer to your laboratory exercise in Week 1 for the template. Save your output as "SURNAME_FMDTP1" and place it on the network drive. Migatus Enterprise is one of the top retail companies in the Philippines. Mr. Rene Tanasas, its Chief Executive Officer (CEO), wanted to establish a simple income statement model that can forecast its company's income in the next five (5) years. He wanted the model to do some cost analysis which includes knowing the average, weighted average, and median of the costs for each year. Mr. Tanasas knew that aside from being an auditor, you are also a financial modeler; thus, he approached you to create a simple income statement model of its company. He gave you the following information for the past two (2) years of its operations: Revenues Less: Cost of Goods Sold (COGS) Gross Profit Income Statement Less: General, Selling, and Administrative Expenses Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) Less: Depreciation Expense Interest Earnings Before Taxes (EBT) Less: Taxes Net Income 20X1 P300,000 120,000 180,000 20,000 160,000 12,000 3,500 144,500 43,350 P101,150 20X2 P400,000 275,000 125,000 21,200 103,800 12,000 3,500 88,300 26,490 P61,810 Based on the above data, Mr. Tanasas came up with the following assumptions for the next five (5) years: The sales growth will remain constant. The percentage of COGS against sales is equal to the average percentage of the above COGSS. The general and administrative expenses will be P20,000 per year. The interest will increase by P6,500, and the tax rate will decrease to 20%. The depreciation expense is equal to 4% of sales. The amount of standard total operating expenses of the company per year is 400,000. The company has the following weight for its costs: Cost of Goods Sold, 55%; . o General, Selling, and Administrative Expenses, 20%; 0 Depreciation Expenses, 10%; O Interest Expenses, 5%; and o Taxes, 10% Required: 1. Create a simple income statement model for Migatsu Enterprise using Microsoft (MS) Excel. You may refer to your laboratory exercise in Week 1 for the template. Save your output as "SURNAME_FMDTP1" and place it on the network drive.
Expert Answer:
Answer rating: 100% (QA)
create a simple income statement model for Migatus Enterprise using Microsoft Excel Heres how you can do it Step 1 Create a new Excel sheet and name i... View the full answer
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these accounting questions
-
1.) The round shaft shown supports a load of F = 18 kN. 35 mm dia. 20 mm dia. r = 1 mm 3mm dia a.) Find the location of highest axial stress in the section shown.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Tonys mother is extremely proud that her son will graduate college in a few months. She expresses concern, however, when Tony tells her that following graduation, he plans to move to Las Vegas to...
-
Diversified Industries is a large conglomerate that is continually in the market for new acquisitions. The company has grown rapidly over the last ten years through buyouts of medium-size companies....
-
Determine the radius of convergence of the following power series. Then test the endpoints to determine the interval of convergence. k 20 xk (2k + 1)!
-
Performance gaps that create potential change situations include the existence of both problems to be resolved and ____________. (a) costs to be avoided (b) people to be terminated (c) problems...
-
Its business involves production of both stock items and custom pieces for doctors at research hospitals. At the end of the third quarter of 2011, it became clear to Ed Walters, chief operating...
-
Sketch the graph of a function f that is continuous on [1, 5] and has the given properties. Absolute maximum at 5, absolute minimum at 2, local maximum at 3, local minima at 2 and 4. 3- 2.5 2 O'S I...
-
Erma, a merchant, receives a brochure from Ammco regarding some merchandise that is sold in Ermas business. Erma then sends in a purchase order ordering 25 units of merchandise (which exceeds $500.00...
-
Please read Practicum 5.5 on page 102 and view these links. - https://canestrinilex.com/en/readings/lifeboat-case-is-murder-allowed-by-necessity-queen-vs-dudley-and-stephens/ -...
-
A shipment was delivered to Chart House restaurant in DanaPoint. Maria, who was in charge of receiving, halfheartedlyinspected the shipment and immediately proceeded to store theitems. First, she...
-
WHAT IS THE TOTAL OPERATING CAPITAL IN BOTH 1998 AND 1999. 1998 1999 Assets Cash and Equivalents 1,750 2,090 Marketable Securities 1,400 2,500 Accounts Receivable 3,450 4,620 Inventories 4,890 5,990...
-
8(a) A particle moves in a straight line with an acceleration kv. If its initial velocity is u, find the velocity and the time spent when the particle has travelled a distance x. 9 (b) A particle of...
-
CASE #4 This is a case study that focuses on the coffee industry. We are asking, the class, to consider the coffee supply chain and generate ideas for what can be done to equalize returns across...
-
Mr. O'Malley is a small, bent, disheveled 63-year-old man with a very faint Irish accent. He was referred for psychiatric evaluation when he attended the medical clinic where he was being followed...
-
F.(3e* -2x 3 sin(2x)) is equal to 2 3 Cos 8. IT 3, t (4+@ 2 3, 1+o 1 4 Cos 4 4 1 3. 1 +4cos V7 (1+o 4 1 4 Cos 4 1+0 4-
-
Do you agree that the international marketer does not need to study the culture from a narrow perspective, but rather needs only a broad perspective to learn about general patterns and themes?...
-
Introduction Dell, Inc. was the worlds market leader in personal computers using direct sales through the Internet and over the telephone until 2005. In 2006, it experienced an unexpected decline in...
-
Using the variables shown in Table 5.5 develop operational measures of each, specify differential weights you feel are realistic, and apply these for a matrix analysis (such as shown in Figure 5.5)...
-
The Mendoza Company is installing an absorption standard-costing system and a flexible-overhead budget. Standard costs have recently been developed for its only product and are as follows: Expected...
-
The expected activity of the paper-making plant of Leventhal Paper Company was 45,000 machine hours per month. Practical capacity was 60,000 machine hours per month. The standard machine hours...
-
Precision AutoParts Company has a highly automated manufacturing process for producing a variety of auto parts. Through the use of computer-aided manufacturing and robotics, the company has reduced...
Study smarter with the SolutionInn App