The client has provided you with the calculations below, and asked you to determine whether an...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The client has provided you with the calculations below, and asked you to determine whether an investment in sector (X) is a profitable investment. We ask you to answer this question through the "worksheet", by calculating the ratios in the table Sector A sales price returns The price of the goods sold (25 riyals per unit) gross profit General, administrative and sales expenses Capital expenditure (one-time price of development) eg investment Consumption Earnings before income tax Income tax (35%) net income sales price returns annual cash flow accumulated cash flow Sector B sales price returns The price of the goods sold (25 riyals per unit) gross profit General, administrative and sales expenses Capital expenditure (one-time price of development) eg investment Consumption Earnings before income tax Income tax (35%) net income annual cash flow accumulated cash flow Sector C The price of the goods sold gross profit General, administrative and sales expenses Capital expenditure (one-time price of development) eg investment Consumption Earnings before income tax Income tax (35%) net income annual cash flow accumulated cash flow Unit # number of units SAR per unit SAR per unit SAR SAR SAR SAR SAR Unit # number of units SAR per unit SAR per unit SAR SAR SAR SAR SAR Unit # number of units SAR per unit 35 SAR per unit SAR SAR SAR SAR SAR year0 8,000,000 -8,000,000 -8,000,000 year0 0 8,000,000 year0 0 -8,000,000 -8,000,000 8,000,000 0 -8,000,000 -8,000,000 year1 100,000 40 year1 100,000 100,000 100,000 1,100,000 1,100,000 1,100,000 385,000 385,000 385,000 715,000 715,000 715,000 80,000 30 year2 50,000 450,000 157,500 292,500 100,000 40 ear1 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 300,000 300,000 300,000 300,000 300,000 120,000 40 year2 200,000 100,000 35,000 65,000 80,000 30 year3 100,000 40 715,000 715,000 715,000 715,000 715,000 715,000 (7,285,000) (6,570,000) (5,855,000) (5,140,000) (4,425,000) (3,710,000) 3,999,999.28 50,000 450,000 157,500 292,500 120,000 40 292,500 292,500 292,500 (7,707,500) (7,415,000) (7,122,500) year3 200,000 100,000 35,000 65,000 80,000 30 50,000 450,000 157,500 292,500 4,800,000 4,800,000 4,800,000 4,200,000 4,200,000 4,200,000 600,000 600,000 600,000 300,000 300,000 300,000 year4 120,000 40 100,000 40 200,000 100,000 35,000 65,000 year4 80,000 30 year5 100,000 40 100,000 100,000 100,000 1,100,000 1,100,000 1,100,000 385,000 385,000 385,000 715,000 715,000 715,000 50,000 450,000 157,500 292,500 120,000 40 year5 200,000 100,000 35,000 65,000 80,000 30 50,000 450,000 157,500 292,500 year5 year6 120,000 100,000 40 40 200,000 100,000 35,000 65,000 65,000 65,000 65,000 65,000 65,000 (7,935,000) (7,870,000) (7,805,000) (7,740,000) (7,675,000) year6 80,000 30 50,000 450,000 157,500 292,500 292,500 292,500 292,500 292,500 (6,830,000) (6,537,500) (6,245,000) (5,952,500) year7 year6 100,000 40 120,000 40 100,000 1,100,000 385,000 715,000 200,000 100,000 35,000 65,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 year7 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 800,000 800,000 800,000 800,000 300,000 300,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 300,000 80,000 30 50,000 450,000 157,500 292,500 year8 year7 100,000 40 120,000 40 100,000 1,100,000 385,000 715,000 200,000 100,000 35,000 65,000 715,000 715,000 715,000 715,000 715,000 (2,995,000) (2,280,000) (1,565,000) (850,000) (135,000) year8 80,000 30 50,000 450,000 157,500 292,500 year9 100,000 40 ear8 120,000 40 200,000 100,000 35,000 65,000 year9 80,000 30 year10 50,000 450,000 157,500 292,500 100,000 40 100,000 100,000 100,000 100,000 1,100,000 1,100,000 1,100,000 1,100,000 385,000 385,000 385,000 385,000 715,000 715,000 715,000 715,000 ar9 120,000 40 year10 200,000 100,000 35,000 65,000 80,000 30 year11 50,000 450,000 157,500 292,500 292,500 292,500 292,500 292,500 (5,660,000) (5,367,500) (5,075,000) (4,782,500) 100,000 40 year10 120,000 40 year11 200,000 100,000 35,000 65,000 80,000 30 50,000 450,000 157,500 292,500 year12 ar11 100,000 40 120,000 40 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,200,000 4,200,000 4,200,000 4,200,000 4,200,000 4,200,000 4,200,000 600,000 600,000 600,000 600,000 600,000 300,000 4,200,000 4,200,000 600,000 600,000 600,000 300,000 600,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 200,000 100,000 35,000 65,000 715,000 580,000 year12 80,000 30 50,000 450,000 157,500 292,500 292,500 (4,490,000) ar12 120,000 40 200,000 100,000 35,000 65,000 65,000 65,000 65,000 65,000 65,000 65,000 65,000 (7,610,000) (7,545,000) (7,480,000) (7,415,000)| (7,350,000) (7,285,000) (7,220,000) The client has asked you to calculate the ratios and variables below in order to know whether the investment is financially viable or not. Sector A Return on investment per year 4 capital recovery period EBITDA year1 Sector B Return on investment per year 4 capital recovery period EBITDA year1 Sector C Return on investment per year 4 capital recovery period EBITDA year1 Sector averages (for comparison) Return on investment per year 4 capital recovery period EBITDA year1 Return on investment per year 4 capital recovery period EBITDA year1 Return on investment per year 4 capital recovery period EBITDA year1 7.50% 13 years 1,050,000 3.75% more than 15 years 700,000 0.88% more than 15 years 450,000 The client has provided you with the calculations below, and asked you to determine whether an investment in sector (X) is a profitable investment. We ask you to answer this question through the "worksheet", by calculating the ratios in the table Sector A sales price returns The price of the goods sold (25 riyals per unit) gross profit General, administrative and sales expenses Capital expenditure (one-time price of development) eg investment Consumption Earnings before income tax Income tax (35%) net income sales price returns annual cash flow accumulated cash flow Sector B sales price returns The price of the goods sold (25 riyals per unit) gross profit General, administrative and sales expenses Capital expenditure (one-time price of development) eg investment Consumption Earnings before income tax Income tax (35%) net income annual cash flow accumulated cash flow Sector C The price of the goods sold gross profit General, administrative and sales expenses Capital expenditure (one-time price of development) eg investment Consumption Earnings before income tax Income tax (35%) net income annual cash flow accumulated cash flow Unit # number of units SAR per unit SAR per unit SAR SAR SAR SAR SAR Unit # number of units SAR per unit SAR per unit SAR SAR SAR SAR SAR Unit # number of units SAR per unit 35 SAR per unit SAR SAR SAR SAR SAR year0 8,000,000 -8,000,000 -8,000,000 year0 0 8,000,000 year0 0 -8,000,000 -8,000,000 8,000,000 0 -8,000,000 -8,000,000 year1 100,000 40 year1 100,000 100,000 100,000 1,100,000 1,100,000 1,100,000 385,000 385,000 385,000 715,000 715,000 715,000 80,000 30 year2 50,000 450,000 157,500 292,500 100,000 40 ear1 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 300,000 300,000 300,000 300,000 300,000 120,000 40 year2 200,000 100,000 35,000 65,000 80,000 30 year3 100,000 40 715,000 715,000 715,000 715,000 715,000 715,000 (7,285,000) (6,570,000) (5,855,000) (5,140,000) (4,425,000) (3,710,000) 3,999,999.28 50,000 450,000 157,500 292,500 120,000 40 292,500 292,500 292,500 (7,707,500) (7,415,000) (7,122,500) year3 200,000 100,000 35,000 65,000 80,000 30 50,000 450,000 157,500 292,500 4,800,000 4,800,000 4,800,000 4,200,000 4,200,000 4,200,000 600,000 600,000 600,000 300,000 300,000 300,000 year4 120,000 40 100,000 40 200,000 100,000 35,000 65,000 year4 80,000 30 year5 100,000 40 100,000 100,000 100,000 1,100,000 1,100,000 1,100,000 385,000 385,000 385,000 715,000 715,000 715,000 50,000 450,000 157,500 292,500 120,000 40 year5 200,000 100,000 35,000 65,000 80,000 30 50,000 450,000 157,500 292,500 year5 year6 120,000 100,000 40 40 200,000 100,000 35,000 65,000 65,000 65,000 65,000 65,000 65,000 (7,935,000) (7,870,000) (7,805,000) (7,740,000) (7,675,000) year6 80,000 30 50,000 450,000 157,500 292,500 292,500 292,500 292,500 292,500 (6,830,000) (6,537,500) (6,245,000) (5,952,500) year7 year6 100,000 40 120,000 40 100,000 1,100,000 385,000 715,000 200,000 100,000 35,000 65,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 4,000,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 year7 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 1,600,000 800,000 800,000 800,000 800,000 300,000 300,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 800,000 300,000 300,000 80,000 30 50,000 450,000 157,500 292,500 year8 year7 100,000 40 120,000 40 100,000 1,100,000 385,000 715,000 200,000 100,000 35,000 65,000 715,000 715,000 715,000 715,000 715,000 (2,995,000) (2,280,000) (1,565,000) (850,000) (135,000) year8 80,000 30 50,000 450,000 157,500 292,500 year9 100,000 40 ear8 120,000 40 200,000 100,000 35,000 65,000 year9 80,000 30 year10 50,000 450,000 157,500 292,500 100,000 40 100,000 100,000 100,000 100,000 1,100,000 1,100,000 1,100,000 1,100,000 385,000 385,000 385,000 385,000 715,000 715,000 715,000 715,000 ar9 120,000 40 year10 200,000 100,000 35,000 65,000 80,000 30 year11 50,000 450,000 157,500 292,500 292,500 292,500 292,500 292,500 (5,660,000) (5,367,500) (5,075,000) (4,782,500) 100,000 40 year10 120,000 40 year11 200,000 100,000 35,000 65,000 80,000 30 50,000 450,000 157,500 292,500 year12 ar11 100,000 40 120,000 40 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,200,000 4,200,000 4,200,000 4,200,000 4,200,000 4,200,000 4,200,000 600,000 600,000 600,000 600,000 600,000 300,000 4,200,000 4,200,000 600,000 600,000 600,000 300,000 600,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 200,000 100,000 35,000 65,000 715,000 580,000 year12 80,000 30 50,000 450,000 157,500 292,500 292,500 (4,490,000) ar12 120,000 40 200,000 100,000 35,000 65,000 65,000 65,000 65,000 65,000 65,000 65,000 65,000 (7,610,000) (7,545,000) (7,480,000) (7,415,000)| (7,350,000) (7,285,000) (7,220,000) The client has asked you to calculate the ratios and variables below in order to know whether the investment is financially viable or not. Sector A Return on investment per year 4 capital recovery period EBITDA year1 Sector B Return on investment per year 4 capital recovery period EBITDA year1 Sector C Return on investment per year 4 capital recovery period EBITDA year1 Sector averages (for comparison) Return on investment per year 4 capital recovery period EBITDA year1 Return on investment per year 4 capital recovery period EBITDA year1 Return on investment per year 4 capital recovery period EBITDA year1 7.50% 13 years 1,050,000 3.75% more than 15 years 700,000 0.88% more than 15 years 450,000
Expert Answer:
Answer rating: 100% (QA)
Profitability Analysis of Investment in Sector 00 Based on the provided information lets analyze the profitability of an investment in Sector 00 compa... View the full answer
Related Book For
Auditing A Practical Approach
ISBN: 9780730382645
4th Edition
Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these accounting questions
-
10 25. Given the circuit below, label the inputs appropriately (Io through I7) so that the circuit performs the proper function of an 8 to 1 MUX. 0 2-to-1 MUX, 8-to-1 MUX D 26. 1 S 0 2-to-1 MUX 0...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
You meet with the partner, Aram Anzari, who has instructions for a special personal tax return to prepare. Aram asks you to prepare the 2017 tax returns for his good friends Kathy and Kevin Dhaliwal....
-
Let a function f be the line graph connecting the data points (1, 2), (4,9), and (6,3). (a) Write the formula for a piecewise-linear function f that passes through these data points whose domain is 1...
-
The price of Garner stock is $40. There is a call option on Garner stock that is at the money, with a premium of $2.00. There is a put option on Garner stock that is at the money, with a premium of...
-
Wild geese are known for their lack of manners. One goose is flying northward at a level altitude of = 30.0 m above a north-south highway, when it sees a car ahead in the distance moving in the...
-
Lucenay Interiors, a furniture store, was formed on January l, 2008, when lucenay issued common stock for \($400,000.\) Early in January, Lucena) made the following cash payments: a. \($100,000\) for...
-
List the six building blocks that make up digital computers, and describe the flows of data that occur among these blocks.
-
i. Calculate the value of Macaulay's duration for a 10-year, $1000 par value bond purchased today at a yield to maturity of 14% and a coupon rate of 10%. ii. From the answer in (i) calculate the...
-
Suppose that East-West airlines is a small airline that offers passanger air transportation between two major east coast cities, namely Boston and New York; two major west coast cities , namely San...
-
Question 2: The 2015 comparative income statement and the 2015 comparative balance sheet of Golf America, Inc. have just been distributed at a meeting of the company's Board of Directors. The members...
-
The system shown consists of 3 cables. For example; cable C12 joins points 1 and 2. The coordinates of point 1 are (6.4, 0, 0) m, those of point 2 are (0, 9.5, -6.1) m, and those of point 3 are (0,...
-
A light - rail commuter train has a top speed of 8 3 . 2 km / h . In emergencies the train can decelerate rapidly, coming to rest in 1 1 . 7 7 s . What is the magnitude of its emergency break...
-
While entering a freeway, a car accelerates from an initial 1 . 6 m / s at a rate of 2 . 7 3 m / s 2 , for 1 5 . 4 s . How far does the car travel in this time in meters?
-
Freight trains can produce only relatively small accelerations and decelerations. What is the final velocity of a freight train that accelerates from rest at a rate of 0 . 0 9 0 1 m / s ^ 2 for 6 . 9...
-
In a fast-food restaurant, the manager observes that the average inter-arrival time between customers is three minutes with a standard deviation of four minutes. The service time for a customer is...
-
1. 10+16 Directions: Simplify each expression. 6.|-14| 7. |15|-|-9| Topic 2: Fractions, Decimals, & Percents Directions: Complete the chart below. 10. 11. 12. 13. 3 14.-1+1= 4 Find each sum,...
-
Ball bearings are widely used in industrial applications. You work for an industrial food machinery manufacturer and your role is to design the driveshaft assembly on a new type of equipment that...
-
When an audit test reveals an error or exception, the auditor should: (a) Try to understand why the error or exception has occurred. (b) Consider increasing the sample size. (c) Consider additional...
-
Inspecting documents, such as an invoice for the purchase of fi xed assets, provides the auditor with evidence relevant to the: (a) Rights and obligations assertion, because the document will show...
-
The following client- prepared bank reconciliation is being examined by Zachary Kallick, CPA, during the examination of the financial statements of Simmons Company. Required: Items (a) through (e)...
-
The valve mechanism in Figure 2.41 is in equilibrium when the rocker arm is horizontal. The system is assumed to be frictionless. Use an energy method to determine the natural frequency for small...
-
A rod is supported on two rotating grooved rollers, as depicted in Figure 2.42. The rollers rotate in opposite directions and the coefficient of friction between the rollers and the rod is...
-
A \(25-\mathrm{kg}\) block is suspended by two cables, as depicted in Figure 2.43. Assume small displacements. (a) What is the frequency of oscillation in \(\mathrm{Hz}\) of the block in the \(x\)...
Study smarter with the SolutionInn App