Question

In: Finance

I wonder how is the FORMULA TO CALCULATE % change in sales, Projected total assets, and...

I wonder how is the FORMULA TO CALCULATE % change in sales, Projected total assets, and Projected Current Liabilities!

I know the answer but I do not know where does the answer comes from. I NEED A FORMULA. NOT JUST A NUMBER

Here is the question and answer :

XYZ has the following financial information for 2018:

  • Sales = $2M, Net Inc. = $0.4M, Div. = $0.1M
  • C.A. = $0.4M, F.A. = $3.6M

C.L. = $0.2M, LTD = $1M, C.S. = $2M, R.E. = $0.8M

If 2019 sales are projected to be $2.4M, what is the amount of external financing needed, assuming XYZ is operating at full capacity, and profit margin and payout ratio remain constant?

Projected total assets                             = 4 X (1+0.2) = 4.8

Projected Current Liabilities                      = 0.2 X (1+0.2) = 0.24

% change in sales                                = 2.4-2/ 2  = 0.2

Solutions

Expert Solution

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

I have written all formulas and solve accordingly, go through, Thank you


Related Solutions

Projected Operating Assets Formula Explanation Berman & Jaccor Corporation's current sales and partial balance sheet are...
Projected Operating Assets Formula Explanation Berman & Jaccor Corporation's current sales and partial balance sheet are shown below. This year Sales $ 1,000 Balance Sheet: Assets Cash $ 100 Short-term investments $ 70 Accounts receivable $ 200 Inventories $ 200     Total current assets $ 570 Net fixed assets $ 450     Total assets $ 1,020 Sales are expected to grow by 12% next year. Assuming no change in operations from this year to next year, what are the projected total operating...
Sales are expected to grow by 12% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets?
Projected Operating AssetsBerman & Jaccor Corporation's current sales and partial balance sheet are shown below.This yearSales$1,000Balance Sheet: AssetsCash$100Short-term investments$75Accounts receivable$300Inventories$150    Total current assets$625Net fixed assets$400    Total assets$1,025Sales are expected to grow by 12% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round intermediate calculations. Round your answer to the nearest dollar.$  
As of the end of the first year of operations, the projected total current assets is?
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years. Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals....
Is there a formula to quickly calculate amortized interest? I know how to do it for...
Is there a formula to quickly calculate amortized interest? I know how to do it for each individual payment period (interest= [principle amount]x[interest rate]) and subtracting the amount of the payment that goes towards the principle, and doing it over and over again. However, this process takes too long once you get more payment periods. I am trying to answer the following question: Q: You have paid for 20 years of your 30 year mortgage and make monthly payments of...
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving...
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions: You will charge $995 per person for a two-day class. You estimate that 30 people will attend the class, but you should keep an option to change this input. Your fixed costs include $500 total to rent a room for both days, setup fees of $500 for registration, and $300 for designing a postcard for...
Given the following information, calculate the ROE. Sales = $350,000; Net Income = $50,000; Total assets...
Given the following information, calculate the ROE. Sales = $350,000; Net Income = $50,000; Total assets = $500,000; D/E = 1.5. a. 30% b. 20% c. 15% d. 25% e. 10%
why would manager care about total sales,total collections, % collected( =collections/sales) and total commission( formula is...
why would manager care about total sales,total collections, % collected( =collections/sales) and total commission( formula is if % collected<35%, commission= $0, if %collected > 35%, commission= sales* 5%)
How to calculate Return on Equity?(I just want to learn the formula, no specific data) If...
How to calculate Return on Equity?(I just want to learn the formula, no specific data) If the return on equity is low, how can it be improved? Net Earnings per share Retained earnings, beginning of the year Dividends paid Selling and Admin Expense Operating Profit Interest Expense Income Taxes Net Earnings Retained earnings, end of year Net Sales Cost of goods sold Other income (expense), net Earnings before income taxes
A pro forma statement indicates that both sales and fixed assets are projected to increase by...
A pro forma statement indicates that both sales and fixed assets are projected to increase by 7 percent over their current levels. Given this, you can safely assume that the firm: a. is projected to grow at the internal rate of growth. b. is projected to grow at the sustainable rate of growth. c. currently has excess capacity. d. is currently operating at full capacity. e. retains all of its net income.
(a) Ericson Corporation’s total assets are projected to increase by $30 million next year. Ericson is...
(a) Ericson Corporation’s total assets are projected to increase by $30 million next year. Ericson is also scheduled to repay $14 million in debt next year. Other than this repayment, no changes in liabilities are currently scheduled. Ericsons’s income is projected to be $4 million, half of which will be paid as a dividend. What is the amount of Ericson’s External Funds Needed (EFN) for next year? (b) Ericson’s $4 million net income consists of $33 million in revenues, less...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT