Soporific Games has forecast sales of $621,568 next year. Given the data in the table, what will growth CAPEX be next year? Selected Financial Information Arctic Cat Dog Sleds Inc. Sales Net PP&E Depreciation Rate gCAPEX/ASales, gx Last Year 563,613 59,497 26.10% 57.38% Next Year 621,568 84,029
Q: Problem #4 Apply goal seek to calculate the number of units needed to achieve a total net revenue.…
A: Total Net Revenue = (Retail Price * Number of units)*(1-Selling discount %)
Q: Blue Angel, Inc., a private firm in the holiday gift industry, is considering a new proje The…
A: NPV is the most used Capital Budgeting technique used to evaluate the projects for the capital…
Q: Tatsuo has just been awarded a four-year scholarship to attend the university of his choice. The…
A: Time = t = 4 YearsPayment = p = $16,000Interest Rate = r = 4.5%
Q: You find the following corporate bond quotes. To calculate the number of years until maturity,…
A: The corporate bond issued by Company X will have a future worth of $2000. The bond is priced at a…
Q: Assume a 30 year fixed rate, fully amortizing mortgage for $260,000 at a stated rate of 5% fees,…
A: Payment per period can be calculated using PMT function in excel.PMT(rate, nper, pv, [fv],…
Q: Emilo is a seaman in the U.S. Navy who served in a combat zone from January 30, 2022 to July 3,…
A: The objective of the question is to determine the number of months of Emilo's income that are…
Q: Remex (RMX) currently has no debt in its capital structure. The beta of its equity is 1.44. For…
A: Unlevered cost of equity is the cost of equity when there is no debt in the capital structure of the…
Q: A company decides to close down its plastics division. It has on hand 20 tons of styrens monomer, a…
A: Value of the 20 tons of styrene monomer to the company =In hand no. of units of styrene monomer X…
Q: Consider the following table for the period from 1973 through 1980. Year 1973 1974 1975 1976 1977…
A: Excel workings:-ResultAverage return for treasury bills = 7.47%Average annual inflation rate =…
Q: Consider the following two projects, X and Y: Period Project X Project Y 0 $(100,000) $(120,000) 1…
A: nternal rate of return(IRR) is the discount rate that equates the NPV of an investment opportunity…
Q: The effective interest rate to the nearest percent for the financing arrangement for the five annual…
A: The effective rate of interest, also known as the effective annual rate (EAR) or annual equivalent…
Q: Suppose today is Dec 31st 2018. The stock of Alliant Energy Corp. will pay a dividend of $0.36 every…
A: Current Stock Price= Sum of the Present Values of the Quarterly Dividends + Present Value of the…
Q: Harriet Marcus is concerned about the financing of a home. She saw a small cottage that sells for…
A: Loan amount= Amount of cottage * (1-Down payment %)= 75000*(1-20%)= 60000
Q: The table below shows the closing monthly stock prices for Penn Company and Teller, Incorporated.…
A: Moving average= Sum of Stock prices of last 3 months / 3
Q: Asset allocation is the decision of how you divide your investment portfolio between various assets.…
A: The distribution of securities in a portfolio based on how the risk bearing capacity of an investor…
Q: Slow Roll Drum Co. is evaluating the extension of credit to a new group of customers. Although these…
A: Net sales = $288,000- (288,000*10%) = $259,200The production and marketing costs represent 70% of…
Q: Which of the following are common use cases for VLOOKUP? (Check all that apply) Check All That Apply…
A: The objective of the question is to identify the common use cases for the VLOOKUP function in Excel.…
Q: A fully amortizing mortgage loan is made for $100,000 for 15 years. The interest rate is 6 percent…
A: Loan installment is that which is paid by borrower to lender for a specified period of time. This…
Q: On your 35th birthday, you open a retirement account that pays 6% interest each year. You want to…
A: Annuity refers to a series of cash flow that occurs periodically and at constant intervals. Here the…
Q: continuing for a total of 3 consecutive years. Calculate the profitability index for the office…
A: The profitability index (PI) is calculated by dividing the present value of future cash flows by the…
Q: The last two quarters have seen a decline in prices. Consumers have cut back on their purchases and…
A: In this question, we are required to determine the name given to the situation described in the…
Q: Compare the alternatives shown on the basis of their capitalized costs using a MARR of 10% per year.…
A: Alternative M:First cost= -$150000Annual cost= -$80000Salvage value= $8000Life(n)= 5…
Q: A bond issued by IBM on December 1, 1996, is scheduled to mature on December 1, 2096. If today is…
A: In this question, we are required to determine the bond's time to maturity.
Q: By purchasing training software for $8,000, you can eliminate other training costs of $3,675 each…
A: NPV is the difference between present value of cash inflows and initial cost. It should be positive…
Q: Consider the following table for a period of six years. Returns Large-Company Stocks -14.69% -26.47…
A: a&b. Calculation of the arithmetic average and standard deviation of the returns:Formula used:
Q: Equipment with a book value of $82,000 and an original cost of $164,000 was sold at a loss of…
A: Cash flows from investing activities represent the cash inflows and outflows a company experiences…
Q: What is the duration of an 8% coupon bond (coupons paid annually) with three years until maturity?
A: Bonds are the financial instruments issued by firms to holders for a specific time period. This is a…
Q: Winnebagel Corp. currently sells 39,807 motor homes per yea at $66,583 each and 9,823 luxury motor…
A: Number of units of motor homes sold = 39,806Selling price of motor homes = $66,583Number of units of…
Q: Bearcat Corporation is offering bonds to the market with a coupon of 15 percent. The bonds make…
A: The current worth of the bond can be found by using the PV function in the Excel sheet where the…
Q: Acort Industries has 8 million shares outstanding and a current share price of $43 per share. It…
A: WACC means weighted average cost of capital.It is computed as follows:-WACC =…
Q: A portfolio has 30% invested in stock A and the rest invested in stock B. If stock A has a beta of…
A: In this question, we are required to determine the portfolio beta.
Q: Five year ago, the 10-year bond was paying 9.5%. At the same time, the 5-year bond was paying just…
A: Variables in the question:Let current 5 year rate be denoted by RLet 5 year rate, five year ago be…
Q: 1) What was the ethical misconduct in the WorldCom case? 2) What management behaviors led to the…
A: In this question, we are required to determine the ethical misconduct in WorldCom case.
Q: You bought 2 0 year bonds which has a total Face Value of 5 , 0 0 0 , 0 0 0 and has a coupon rate of…
A: Bond yield refers to the rate of return at which bond generates the income from the bond.It has an…
Q: An investor has $100,000 to invest. If she invests 40% in Stock A, 30% in Stock B, and the remainder…
A: Weight of Stock A = wa = 40%Weight of Stock B = wb = 30%Weight of market index exchange traded fund…
Q: Rust Industrial Systems Company is trying to decide between two different conveyor belt systems.…
A: NPV or Net Present value refers to the concept of capital budgeting to evaluate the profitability of…
Q: If you would like to put $300 (monthly) in 401K generating 8% of APR, how much you will have at the…
A: Future value of money is the amount of deposit done plus large amount of interest accumulated due to…
Q: AEP's outstanding bonds have a $1,000 par value, and they mature in 25 years. The yield to maturity…
A: Semiannual coupon payment is calculated using PMT function in Excel :PMT(rate, nper, pv, [fv],…
Q: Oriole Mills management is evaluating two alternative heating systems. Costs and projected energy…
A: If NPV of project is positive, Project must be accepted.If NPV of project is negative, Project must…
Q: Suppose Goodyear Tire and Rubber Company is considering divesting one of its manufacturing plants.…
A: Required return is computed as follows:-k = (ke*we)+(kd*wd)wherek=Required returnke= cost of…
Q: If closing costs of $2,800 are associated with the refinance of a mortgage that would reduce the…
A: Time period required to recover the cost of refinancing= Cost of Refinancing / Reduction in monthly…
Q: Greta has risk aversion of A=4 when applied to return on wealth over a one-year horizon. She is…
A: S&P 500Risk-premium =5%SD =17%Hedge fundRisk-premium=10%SD=32%
Q: You are a consultant who has been hired to evaluate a new product line for Markum Enterprises. The…
A: The net present value illustrates a project's profitability. A useful metric for assessing an…
Q: A fully amortizing mortgage is made for $112,000 at 6.5 percent interest. Required: If the monthly…
A: Mortagage amortization refers to the systematic repayment of loan and interest. Equal and regular…
Q: If you borrow $11,472 and are required to pay back the loan in five equal annual installments of…
A: Yield to maturity can be calculated by following function in excel=RATE (nper, pmt, pv, [fv],…
Q: A binomial tree prices an American option at $3.12 and the corresponding European option at $3.04.…
A: In this question, we are required to determine the Control Variate Price.
Q: You are 20 years old today. You want to retire at age 50 and have $4 million at that time. Assume…
A: The present value of money refers to the concept that money available in the future is worth less…
Q: Oklahoma Instruments has a bond issue outstanding that pays $60 annually. It has a face value of…
A: Price / Present Value can be calculated using PV function in excelPV (rate, nper, pmt, [Fv],…
Q: Yellow Day has a project with the following cash flows: Year Cash Flows 0 -$ 26,700 1 10,400 2…
A: Future value can be calculated usingFV = PV* (1 + r / n)ntWhere,PV = Present valueFV = Future valuer…
Q: Net income for the previous year was $400,000, of which $280,000 was paid out in dividends.…
A: P/E ratio is the ratio of price of the stock today to the EPS of the company and used for…
please answer fast i give upvote
Step by step
Solved in 3 steps
- Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's salesConsider the following information that you propose to use to obtain an estimate of year 2004 EPS for the MacLog Company. Estimated Year 2019 Year 2020 GDP 11,000 Billion GDP growth 3.5% Sales per share $800 Operating profit margin 12% Depreciation/Fixed Assets 14% Fixed asset turnover 2 Interest rate 3.5% Total asset turnover 0.7 Debt/Total assets 45% Tax rate 36% In addition, a regression analysis indicates the following relationship between growth in sales per share for MacLog, and GDP growth is %Δ Sales per share = 0.015 + 0.75(%Δ GDP) Refer to Exhibit 9.6. Calculate the firm's level of Total Assets per share for the year 2020. a. $1,385.77 b. $1,113.58 c. $1,050.65 d. $1,065.67 e. $1,190.06Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,500,000 $1,670,000 $1,580,000 $2,160,000 $1,890,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. Next year's sales
- The Blazer Company's EPS last year, EPSo, was $1.50. Blazer expects sales to increase by 15% during the coming year. If Blazer has a degree of operating leverage equal to 1.25 and a degree of financial leverage equal to 3.50, then what is its expected EPS or EPS₁? Hint: First, find DTL where DTL= DOL x DFL. Note: This is a web appendix 14A topic. O $2.48 O $2.87 O $2.02 O $1.66Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,530,000 $1,720,000 $1,560,000 $2,100,000 $1,850,000 What would be the forecast for next year’s sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar.Suppose a firm has had the historical sales figures shown as follows. What would be the forecast for next year's sales using the average approach? Year 2017 2018 Sales $ 750,000 500,000 Multiple Choice O $695,000 $700,000 $750,000 $775.000 2019 $ 700,000 2020 $ 750,000 2021 $ 775,000
- Suppose a firm has had the following historic sales figures. Year: 2016 Sales $1,420,000 2017 $1,720,000 Next year's sales 2018 2019 2020 $1,600,000 $2,010,000 $1,770,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. 27Oman Cement has the following returns. Beginning value%3DOMR. 1000, End of Year1= OMR 1050, End of Year 2-OMR. 1100, End of Year 3=OMR. 1250, End of Year 4= OMR 1300. Calculate Average Annual Growth rate (AAGR) of the company Select one:The current year financial statements of Your Health Corporation reported sales of $142,021 million and accounts receivable of $9,731 million. If sales are projected to increase 4% next year, what is the projected accounts receivable balance for the following year? Note: Use a rounded forecasting factor in your computations (for example, 0.044555 = 4.5%). Select one: O a. $8,659 million O O O O b. $9,920 million c. $8,330 million d. $10,191 million e. $9,731 million
- Suppose a firm has had the following historic sales figures. Year: Sales 2016 $1,900,000 2017 $2,150,000 2018 $1,800,000 2019 $2,400,000 2020 $2,000,000 What would be the forecast for next year's sales using the average approach? Next year's salesSuppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? Year: 2009 2010 2011 2012 2013 Sales $1,500,000 $1,750,000 $1,400,000 $2,000,000 $1,600,000Use the following information from Salalah Packaging Company to calculate Average Annual Growth Rate (AAGR). Beginning value=DOMR. 12100, End of Year 1= OMR 13560, End of Year 2-OMR 14205, End of Year 3=OMR 15347, End of Year 4= OMR 20458.