Money because the more money you invest the mor you have to spend
Answer:
d) negative cash flow appearing in red font.
Explanation:
Colour coding is a type of excel formatting for financial modelling.
Color coding allows anyone to immediately pick up your model and know what can be changed (assumptions) and what should not be altered (formulas).
Example:
negative cash flow (Cash outflow) of the company appears in red font while positive cash flow (Cash inflow) of the company appears in green font.
Sorry, can you show attachments?
The question is incomplete as the figures are missing. The complete question is,
Fosnight Enterprises prepared the following sales budget:
Month Budgeted Sales
March $6,000
April $13,000
May $11,000
June $20,000
The expected gross profit rate is 20% and the inventory at the end of February was $7,000. Desired inventory levels at the end of the month are 30% of the next month's cost of goods sold. What are the total purchases budgeted for May?
Answer:
Purchases - May = $10960
Explanation:
To calculate the total value of purchases that are budgeted for May, we first need to calculate the cost of goods sold and the opening and closing inventory for May.
As the gross profit margin is 20%, the cost of goods sold will be 80% of sales.
Cost of goods sold for May = 0.8 * 11000 = $8800
Cost of goods sold for June = 0.8 * 20000 = $16000
Opening inventory - May = 8800 * 0.3 = $2640
Closing Inventory - May = 16000 * 0.3 = $4800
Purchases = Closing Inventory + Cost of Goods Sold for the month - Opening Inventory
Purchases - May = 4800 + 8800 - 2640
Purchases - May = $10960
Answer:
The solvency ratio is closest to: B. 33%.
Explanation:
<em>The solvency ratio = After tax Net Operating Income ÷ Total Debt</em>
Thus,
The solvency ratio = $75,000 ÷ ($15,000 + $200,000)
= 35.88%
Therefore this is closest to B. 33%.
