Calculate eight ratios ( min. one from every category) from the financial statements of any company for last two years and give interpretation. (Note: Upload images of the financial statements of a company with solution)
In: Accounting
A firm has the following information for the last two years – all amounts are in U.S. dollars.
This year Last year
2019 2018
Revenues 99,000 90,000
EBIT 33,000 30,000
EAT 16,500 15,000
EPS 1.80 1.50
This firm’s Degree of Financial Leverage is:
| a. |
1 |
|
| b. |
3 |
|
| c. |
2 |
|
| d. |
none of the above |
In: Finance
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.
|
Month |
Maintenance and Repair Cost ($000) |
Revenues ($000) |
|
July |
$2.31 |
$59.00 |
|
August |
3.28 |
53.00 |
|
September |
2.80 |
49.00 |
|
October |
2.21 |
65.00 |
|
November |
2.30 |
77.00 |
|
December |
1.14 |
105.00 |
|
January |
3.12 |
45.00 |
|
February |
3.16 |
51.00 |
|
March |
3.02 |
61.00 |
|
April |
2.98 |
63.00 |
|
May |
2.04 |
67.00 |
|
June |
1.78 |
79.00 |
|
July |
2.60 |
73.00 |
|
August |
2.02 |
67.00 |
|
September |
2.57 |
75.00 |
|
October |
2.38 |
77.00 |
|
November |
1.43 |
87.00 |
|
December |
0.76 |
117.00 |
|
January |
2.58 |
61.00 |
|
February |
2.28 |
63.00 |
|
March |
1.69 |
83.00 |
|
April |
1.95 |
87.00 |
|
May |
1.95 |
73.00 |
|
June |
1.33 |
69.00 |
Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be indicated by a minus sign. Round "Multiple R, R square and Standard Error" to 7 decimal places, Intercept and Revenues to 4 decimal places.)
Regression Statistics
Multiple R: 0.8436280
R Square: 0.7117080
Standard Error:
Observations: 24
Coefficients
Intercept:
Revenues:
In: Statistics and Probability
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.
| Month | Maintenance and Repair Cost ($000) | Revenues ($000) |
| July | $1.86 | $50.00 |
| August | 2.83 | 44.00 |
| September | 2.35 | 40.00 |
| October | 1.76 | 56.00 |
| November | 1.85 | 68.00 |
| December | 0.69 | 96.00 |
| January | 2.67 | 36.00 |
| February | 2.71 | 42.00 |
| March | 2.57 | 52.00 |
| April | 2.53 | 54.00 |
| May | 1.59 | 58.00 |
| June | 1.33 | 70.00 |
| July | 2.15 | 64.00 |
| August | 1.57 | 58.00 |
| September | 2.12 | 66.00 |
| October | 1.93 | 68.00 |
| November | 0.98 | 78.00 |
| December | 0.31 | 108.00 |
| January | 2.13 | 52.00 |
| February | 1.83 | 54.00 |
| March | 1.24 | 74.00 |
| April | 1.50 | 78.00 |
| May | 1.50 | 64.00 |
| June | 1.60 | 60.00 |
Required:
Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be indicated by a minus sign. Round "Multiple R, R Square and Standard Error" to 7 decimal places, "Intercept and Revenues" to 4 decimal places.)
|
||||||||||||||||||
In: Accounting
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.
| Month | Maintenance and Repair Cost ($000) | Revenues ($000) |
| July | $1.66 | $46.00 |
| August | 2.63 | 40.00 |
| September | 2.15 | 36.00 |
| October | 1.56 | 52.00 |
| November | 1.65 | 64.00 |
| December | 0.49 | 92.00 |
| January | 2.47 | 32.00 |
| February | 2.51 | 38.00 |
| March | 2.37 | 48.00 |
| April | 2.33 | 50.00 |
| May | 1.39 | 54.00 |
| June | 1.13 | 66.00 |
| July | 1.95 | 60.00 |
| August | 1.37 | 54.00 |
| September | 1.92 | 62.00 |
| October | 1.73 | 64.00 |
| November | 0.78 | 74.00 |
| December | 0.11 | 104.00 |
| January | 1.93 | 48.00 |
| February | 1.63 | 50.00 |
| March | 1.04 | 70.00 |
| April | 1.30 | 74.00 |
| May | 1.30 | 60.00 |
| June | 1.72 | 56.00 |
Required:
Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be indicated by a minus sign. Round "Multiple R, R Square and Standard Error" to 7 decimal places, "Intercept and Revenues" to 4 decimal places.)
|
|||||||||||||||||||
In: Accounting
The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.
| Month | Maintenance and Repair Cost ($000) | Revenues ($000) |
| July | $2.01 | $53.00 |
| August | 2.98 | 47.00 |
| September | 2.50 | 43.00 |
| October | 1.91 | 59.00 |
| November | 2.00 | 71.00 |
| December | 0.84 | 99.00 |
| January | 2.82 | 39.00 |
| February | 2.86 | 45.00 |
| March | 2.72 | 55.00 |
| April | 2.68 | 57.00 |
| May | 1.74 | 61.00 |
| June | 1.48 | 73.00 |
| July | 2.30 | 67.00 |
| August | 1.72 | 61.00 |
| September | 2.27 | 69.00 |
| October | 2.08 | 71.00 |
| November | 1.13 | 81.00 |
| December | 0.46 | 111.00 |
| January | 2.28 | 55.00 |
| February | 1.98 | 57.00 |
| March | 1.39 | 77.00 |
| April | 1.65 | 81.00 |
| May | 1.65 | 67.00 |
| June | 1.51 | 63.00 |
Required:
Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be indicated by a minus sign. Round "Multiple R, R square and Standard Error" to 7 decimal places, Intercept and Revenues to 4 decimal places.)
REGRESSION
STATISTICS
MULTIPLE R ?
R SQUARE ?
STANDARD ERROR ?
OBSERVATIONS ?
COEFFICIENTS
INTERCEPT ?
REVENUES ?
In: Statistics and Probability
In the last two years, a company incurred the
following expenditure in relation to
the development of a new product:
1 Jan 2013 – 31 Dec 2014 (2 years) £1,440,000
The criteria for recognition as an intangible asset were satisfied
from 1 Apr 2014.
For the year end, 31 Dec 2014, the intangible asset will be
recognized in
Statement of Financial Position at?
In: Accounting
Assume that the last two digits on a car number plate are equally likely to be any of the 100 outcomes{00, 01, 02, ........ 98, 99}. Peter bets Paul, at even money, that at least 2 of the next n cars seen will have the same last two digits. Does n=16 favour Peter or Paul? What value of n would make this a pretty fair bet?
In: Math
|
year |
Price of Car(AED) |
Number of Car |
Price of cycle (AED) |
Number of cycle |
|
2017 |
1000 |
10 |
200 |
900 |
|
2018 |
1200 |
15 |
210 |
1000 |
|
2019 |
1500 |
25 |
250 |
1500 |
In: Economics
|
year |
Price of Car(AED) |
Number of Car |
Price of cycle (AED) |
Number of cycle |
|
2017 |
1000 |
10 |
200 |
900 |
|
2018 |
1200 |
15 |
210 |
1000 |
|
2019 |
1500 |
25 |
250 |
1500 |
In: Economics