Answer and Explanation:
a. Proforma income statement
Sales $45,600
Costs $39,120
Net income $6,480
b. Proforma balance sheet
Particulars Amount Liabilities Amount
Assets $32,760 Debt $8,950
Equity $23,810
Total $32,760
External finance = Predicted debt - Beginning debt
= $7,585 - $6,700
= $885
Working note:-
For pro forma statements:
Sales = $38,000 × (1 + 0.20)
= $38,000 × 1.20
= $45,600
Costs = 32,600 × (1 + 0.20)
= $32,600 × 1.20
= $39,120
Net income = Sales - Costs
= $45,600 – 39,120
= $6,480
Assets = 27,300 × (1 + 0.20)
= 27,300 × 1.20
= $32,760
Equity = Beginning balance + Net income - Dividend
= $20,600 + $6,480 - ($6,480 × 1 ÷ 2)
= $20,600 + $6,480 - $3,240
= $23,810
Debt = Assets - Equity
= $31,760 - $23,810
= $8,950
The pro forma statements are prepared by adjusting the sales, costs, and assets by the 20% increase. The net income and dividends are then calculated. The external financing needed is found by deducting the sum of debt, equity and retained earnings from the adjusted total assets.
The pro forma statements are prepared by first adjusting sales, costs, and assets by the predicted increase of 20%. The new sales amount would be $38,000 * 1.20 = $45,600. Costs increase at the same rate, so the new costs would be $32,600 * 1.20 = $39,120. The new assets would be $27,300 * 1.20 = $32,760.
On the pro forma income statement, the net income is calculated by subtracting the new costs from the new sales, which is $45,600 - $39,120 = $6,480. The dividend would be $6,480 * 0.50 = $3,240. The retained earnings (AKA addition to retained earnings) increase by the net income minus the dividends, which is $6,480 - $3,240 = $3,240.
On the pro forma balance sheet, the total assets increased to $32,760. As debt and equity don't change, then they remain at $6,700 and $20,600 respectively. The sum of debt and equity added to the predicted retained earnings is $6,700 + $20,600 + $3,240 = $30,540. Therefore, the external financing needed is the new total assets minus this sum, which is $32,760 - $30,540 = $2,220.
#SPJ3
$ millions 2016 2017 2018 2019 2020 Terminal Period
Sales $15,724 $15,881 $16,199 $16,523 $16,853 $17,022
NOPAT 526 524 535 545 556 562
NOA 3,466 3,500 3,570 3,642 3,715 3,752
Answer the following requirements assuming a discount rate (WACC) of 6%, a terminal period growth rate of 1%, common shares outstanding of 318.3 million, and net nonoperating obligations (NNO) of $242 million.
(a) Estimate the value of a share of Whole Foods' common stock using the discounted cash flow (DCF) model as of September 25, 2016.
Rounding instructions:
Round answers to the nearest whole number unless noted otherwise. Use your rounded answers for subsequent calculations.
Do not use negative signs with any of your answers.
Reported Forecast Horizon
($ millions) 2016 2017 2018 2019 2020 Terminal Period
Increase in NOA Answer Answer Answer Answer Answer
FCFF (NOPAT - Increase in NOA) Answer Answer Answer Answer Answer
Discount factor [1 / (1 + rw)t ] (Round 5 decimal places) Answer Answer Answer Answer
Present value of horizon FCFF Answer Answer Answer Answer
CUMULATIVE present value of horizon FCFF $ Answer
Present value of terminal FCFF Answer
Total firm value Answer NNO Answer
Firm equity value $ Answer
Shares outstanding (millions) Answer (Round one decimal place)
Stock price per share $ Answer (Round two decimal places)
(b) Whole Foods stock closed at $30.96 on November 18, 2016, the date the 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? What do you believe are some reasons for the difference?
A. Stock prices are a function of many factors. It is impossible to speculate on the reasons for the difference.
B. Our stock price estimate is only a few cents lower than the Whole Foods market price, indicating that we believe that Whole Foods stock is accurately priced. Our stock price estimate is lower than the Whole Foods market price, indicating that we believe that Whole Foods stock is overvalued.
C. Stock prices are a function of expected NOPAT and NOA, as well as the WACC discount rate. Our lower stock price estimate might be due to more optimistic forecasts or a lower discount rate compared to other investors' and analysts' model assumptions.
D. Our stock price estimate is lower than the Whole Foods market price, indicating that we believe that Whole Foods stock is undervalued. Stock prices are a function of expected NOPAT and NOA, as well as the WACC discount rate. Our lower stock price estimate might be due to more optimistic forecasts or a lower discount rate compared to other investors' and analysts' model assumptions.
Answer:
Check the explanation for the answer
Explanation:
The price been estimated is bit lower than trading price
The price of the stock is also bit lower with the cents than the whole Foods market price, this indicate that we agree that Whole Foods stock is fixed priced.
Further calculations are been done in the file attached using excel
Answer:
prices rise, employment rises.
Explanation:
In the starting equilibrium price, there would be more demand that result in fall in the firm inventory. Now in order to maintain the level of the inventory the firm would have to rise the production for this the firm should hire more wokers due to this the employment would rise also the wages are more paid as compared to before so it increase the production cost that results in rise in price
Therefore the above represent the answer
Answer:
Explanation:
Antonio used the value of money as a unit of account to compare the value of the two cars namely Super and Duper and come to the conclusion that Duper was cheaper to Super
Antonio saved $ 4000 in his checking account which he gave to the seller. This represent money's role as a store of value
Antonio write a check of the money he saved to the seller and the seller accepted it and gave him the car which fulfill the role of money as a medium of exchange.
Answer:
c. $320
Explanation:
Opportunity cost is an economic term for expressing cost in terms of forgone alternatives. The opportunity cost of Dana is calculated as;
Hours spent baking cookies = 4 hours, the amount earned per hour when Dana is working as yoga instructor = $80.
Therefore, the total opportunity cost of Dana, when she is baking is cookies;
= 4 hours × $80
= $320.
Breon's gross pay for the week is $273.5
Hourly rate for the company = $6.50
Number of hours in the human resource department = 31 hours
Hourly rate at her regular job = $6.5
hours at the front desk = 9 hours
hours at the front desk = 9 hours
rate at the front desk = $1.50
The gross pay =
$6.5 * 31 + 6.5*9 + 9*1.5
= 273.5 dollars
Breon's gross pay is therefore 273.5 dollars
This is the total amount of money that an employee of a company would receive as payment before their taxes and other deductions are removed.
Read more on gross pay here:
Answer:
a. estimate the cost of inventory from incomplete records.
Explanation:
The gross profit method is used to estimate the cost of inventory from incomplete records. This is done by determining the amount of gross profit using the Sales Revenue and the Gross Profit Margin. Then finding the difference between the Cost of Goods available for sale and this Gross Profit to reach to the estimated cost of inventory.