Solution:-
12-month forward PE ratio= Price/12 month forward eps
12 month forward EPS is calculated by calculating EPS attributable to the next 12 months starting from 1st Dec 2019. This is done by using 1 month EPS out of Q4 2019 EPS and adding that to first three quarters EPS of 2020 as well as 2 months EPS out of Q4 2020 EPS.
12 month forward EPS= Earnings from 1st Dec 2019 to 30th Nov 2020 = (Q4 2019*1/3) + Q1 2020 + Q2 2020 + Q3 2020 + (Q4 2020*2/3)
12 month forward EPS= (0.35*1/3) + 0.43 + 0.48 + 0.50 + (0.59*2/3)
12 month forward EPS= 0.117 + 0.43 + 0.48 + 0.50 + 0.393
12 month forward EPS= 1.92
Thus,
12-month forward PE ratio= Price/12 month forward eps = $20/$1.92 = 10.42 times
2. Assume you are at the beginning of December 2019. The stock price of firm A...
Preston Corporation is a manufacturer and distributor of electronic devices. Management has asked you to prepare a cash budget for the upcoming year. The following is the company’s budgeted information for the 2020 fiscal year: Q1 Q2 Q3 Q4 Period end Sales (all on credit) 41,600 33,410 44,850 54,340 174,200 Direct Material Purchases 12,480 10,023 13,455 16,302 52,260 Direct Labor 16,640 13,364 17,940 21,736 69,680 Marketing Expense 4,160 3,341 4,485 5,434 17,420 Building Lease Payments 2,080 2,080 2,080 2,080 8,320...
Stock price of $42, earnings of $2.12 per share during the last
twelve months, forecasted earnings of $2.84 over the following
year, and average earnings growth forecast of 12.5% per year for
the next five years. What is this stock's PEG, rounded to one
decimal place?
Example 5.9: Nike's (NKE) current share price (as of close on 10/24/2019) is $91.50 and earnings per share during the trailing twelve months (EPST: Sum of the last 4 quarters' EPS) was $2.68. Yahoo!...
Budgeting Part 2 (Q 5-9) Dave’s Co. is a manufacturing firm of a computer hardware device. Its sales forecasts for the year 2020 is as follows: Quarter Sales in units Price Revenue Q1, 2020 500 $ 400 $ 200,000 Q2, 2020 1000 400 400,000 Q3, 2020 1000 400 400,000 Q4, 2020 1000 400 400,000 Q1, 2021 2000 400 800,000 Q2, 2021 1500 400 600,000 Q3, 2021 1000 $ 400 $ 400,000 The company will start its business this year with $30,000 of cash balance....
ACC 203-Budgetary Planning Project Fall 2019 DIB corporation’s managerial accountants and the budget committee is meeting in November to prepare the 2019 budget. Your task, as a member of the budget committee, is to prepare the 2019 budget given the following data: Sales: The company expects to sell 40% more units in 2019 than in each quarter of 2018. During 2018, sales were Q1: 40,000; Q2: 30,000; Q3: 60,000 and Q4: 50,000 units. The selling price per unit is expected...
Please answer all of the
questions, thank you!!
Mooney Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first quarter of the next year). The cash collection estimates are based on sales projections and expected collection of receivables. The sales and cash collection estimates are shown in the following table (in millions of dollars): Q1 Q2 Q3 Q4 Q5 Sales $1,210 $1,510 1,560...
At 31st of December 2019, John owned 25% of the common stock capital of a company called Empire’s Investment Ltd. The company focuses on the local real estate market and shows increasing profits year after year. At the beginning of the year 2020 the company presented the following Balance sheet: assets cash 2.005.000,00 land 200.000,00 buildings 1.200.000,00 acc depr buildings -200.000,00 real state available for sale 2.500.000,00 construction in progress 2.300.000,00 total assets 8.005.000,000 liabilities ...
Question 2: On November 1, 2019. Mr. Daniel Kim, an individual
stock investor, pays attention to the news that Dongguk Corp, may
report earnings surprise thanks to the booming demand for natural
gas pipe associated with rising shale gas production in the US. In
order to make an investment judgement through a price multiple
comparison method, Mr. Kim chooses to deploy PER (Price-Earnings
Ratio) computed as following: PER per share stock price of Dongguk
Corp. (November 1, 2019) / expected...
Need Selling & Administrative Expense Budget, Cash Budget,
Budgeted Income Statement for EXCEL.
Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Collections b. Production Budget c. Ending Finished Goods Inventory Budget d. Direct Materials Budget, with a Schedule of Cash Disbursement e. Direct Labor Budget f. Manufacturing Overhead Budget g. Selling & Administrative Expense Budget h. Cash Budget i Budgeted Income Statement Sharp Products is a manufacturing company. It uses absorption costing for budgeting. amount unit...
PLEASE ANSWER IN EXCEL USING FORMULAS Q1 Assume Evco, Inc. has a current stock price of $53.41 and will pay a $2.25 dividend in one year; its equity cost of capital is 11%. What price must you expect Evco stock to sell for immediately after the firm pays the dividend in one year to justify its current price? We can expect Evco stock to sell for $ ___ . (Round to the nearest cent.) Q2. Anle Corporation has a current...
Please show the formulas.
Unique Sinks Master Budget Unique Sinks is a family-owned manufacturing business specializing in sinks; it does not produce any of the faucets or plumbing needed for installation. The company focuses on the new housing market, which has been quite strong for over ten years. Unique Sinks' core competencies include a relatively low- cost but high-quality manufacturing process for sinks. During the last several years, demand for large houses with three to four bathrooms was strong. And...