Answer:
Company X:
Sales :
= Gross Profit + Cost of goods sold
= 245 + 330
= $575
Operating expenses:
= Gross profit - Net income
= 245 - 30
= $215
Company Y
Gross profit:
= Sales - Cost of goods sold
= 1,270 - 790
= $480
Net income:
= Gross profit - Operating expenses
= 480 - 525
= $(45)
Company Z
Operating expenses :
= Gross profit - Net income
= 525 - (-20)
= 525 + 20
= $545
Cost of goods sold:
= Sales - Gross profit
= 970 - 525
= $445
Answer:
12.28%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $1,407
Future value or Face value = $1,000
PMT = $1,000 × 20% = $200
NPER = 9 years
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the answer would be 12.28%
Answer:
$950
Explanation:
Reserve ratio is defined as the percentage amount of deposit that a bank is instructed by the governing central bank to keep as cash reserve. This is used to control the money supply in the economy as the the check - able amount that are subjected to withdrawal is limited to the funds available after the reserve ratio has been considered.
Workings
New deposit - $10,000
Required reserve ratio - 5%
No existing excess ratio as at the time of deposit.
Reserve ratio - 5%*10000 = 50
Increase in checking account = 1000-50
= $950
Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.