A. Develop a linear trend equation for this time series. Round your answers to 4 decimals. Tt = ____+ _____t B. What is the forecast for 16 period ? Round your answer to two decimal places. $_____billion
Q: Capital Healthplans Inc. is evaluating two different methods for providing home health services to…
A: a. The math articulation of the NPV technique infer that task incomes are reinvested at the…
Q: A relatively small privately owned coal-mining company has the sales results summarized below.…
A: Allowed depreciation : Minimum of depreciation and taxable amount. Below is the calculation table-
Q: Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales…
A: The production and materials purchases budgets for the second quarter is as follows:
Q: Given the data here, a. Compute the average return for each of the assets from 1929 to 1940 (the…
A: Use excel as follows to calculate average return , variance and standard deviation
Q: Consider a fictional price index, the College Student Price Index (CSPI), based on a typical college…
A: The consumer price index measures quantifies around a similar monetary wonder as the GDP Deflator. A…
Q: 4. A portfolio manager believes that tomOrTow's foreign exchange of the Euro per US dollar will be…
A:
Q: Lou Silva has owned and operated The Wellness Store for fifteen years. The company's year-end is…
A: Recapture is distinguished when the measure of UCC balance is not exactly the proceed [from your…
Q: Bayan wants to buy a house in six years. She hopes to be able to put down OMR 25000 at that time.…
A: Answer: For solving the question, we will assume that the bank CD will pay the interest in simple…
Q: Yalena Yale has always been proud of her personal investment strategies and has done very well over…
A:
Q: A landscaping company want to plan for the number of employees it needs to hire for upcoming year.…
A: Find the Given details below: Given details: Year Period Demand 2019 Winter 23 Spring 1000…
Q: You have an idea for a new web service that offers customized workouts for subscribers. Build a…
A: given, subscription volume = 60 months total market potential = 100,000
Q: Use the following information for the next four questions: On Jan. 1, 20x1, Red Co. acquires…
A: Principal Amount = ₽500,000 Interest = ₽50,000
Q: The planning committee of a bank makes monthly decisions on the amount of funds to allocate to loans…
A: Given data: To formulate a liner programming model x1,x2,x3,x4,x5,x6,x7 be the decision variables…
Q: . Using the high-low method, express the company’s maintenance costs as an equation where x…
A: Variable cost an be computed as, Variable cost = (Cost at highest activity - Cost at lowest…
Q: CanaSystems is considering a project to build upscale condominiums. They are considering plans on a…
A: Opportunity loss is characterized as the contrast between the real result and the result that would…
Q: Use excel to make the calculations (show formulas used in excel) and be sure to identify your…
A: Give, Huntsville Hays Fixed cost 1100000 1800000 Variable cost 3 2
Q: EFE company manufactures and sells boats. The company's management accountant gathered the following…
A:
Q: Campbell’s Wholesale Company is preparing monthly cash budgets for the fourth quarter of theyear.…
A:
Q: Fox Enterprises is considering six projects for possible construction over the next four ycars. Fox…
A: Let 'Bj' be the sum borrowed for year-j. Change the constraints of the original problems as: 10.5 X1…
Q: The finance managers’ function is to find out how much finances required to acquire fixed assets and…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: Given the following data on inputs and outputs at a work center, determine the cumulative deviation…
A: Calculate Deviation and cumulative deviation for both Input and Output. Deviation is difference…
Q: Great - 600(18) – 6000 = 4800 Figure 6.6 Equivalent Decision Tree 0.45 1074 Fair 0.35 - 300(18) –…
A: Given Information:
Q: The management accountant at Miller Merchandising & More, Odail Russell is in the process of…
A: Cash budget of the organization shows all expected cash collections and cash payments to be made in…
Q: A company has the following alternatives for investment. Using the incremental B/C method, determine…
A: The B/C investigation is a steady examination, even with just a single choice to consider. The…
Q: An investment of $300,000 is expected to generate the following cash inflows in six years: Year 1:…
A: Find the Given Details below: Given Details: Total Investment 300000 $ Cash Inflows Year 1…
Q: Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment…
A: Given data, Economy Has Good Year Economy Has Bad Year Yield on Stocks 22% 10% Yield on…
Q: Coast Corporation's research and development department has a a project to develop a new product…
A: Ethics deals with the decision of what is wrong and what is right according to the situation. On the…
Q: The alternatives shown are to be compared on the basis of their present worth values. At an interest…
A: Given- Particular Alternative B Alternative B First Year -10000 -25000 M/O Cost/year…
Q: Frober Co's institutional investors are becoming increasingly impatient for growth at the company.…
A: Case scenario: In the given scenario reflects the Frober co's is a machinery or plant oriented…
Q: expenditure on food, gas and clothing for a family living in the USA in 2010. Read the description…
A: The above graph seems to be a result of a research. The research process can be defined as the…
Q: 3. The comptroller of Microsoft Corporation has $100 million of excess funds to invest. She has been…
A: Given data: investment funds = 100 mn rate of return - stocks and bonds probabilities
Q: Mickey Limited is a manufacturing business that uses a standard costing system. The company’s flexed…
A: SALES Sales operation is the set of business activities that help a sales organization to run…
Q: Blue Sky Corporation is planning to issue $1,000 par value bonds. The bonds will have a coupon rate…
A: Given that: Face Value = $1000 Market Price = $1050 Coupon Rate = 14% Years of Maturity = 15 years…
Q: Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Below is a list of domestic output and national income figures for a certain year. All figures are…
A: disclaimer: too many questions were asked. GDP can be found by two methods which are the income…
Q: Absorption Costing Operating Income The Southern Division manager of Texcaliber Inc. is growing…
A: Absorption costing, at times called full absorption costing, is a managerial accounting method for…
Q: 20. The Video Game Supply Company (VGS) is deciding whether to set next year's production at 2000,…
A: Decision making is the process of choosing best decision from all available or possible outcome.…
Q: A NEW GENERATOR HAS JUST BEEN INSTALLED. IT IS EXPECTED THAT THERE WILL BE NO MAINTENANCE CHARGES…
A: No maintenance charge untill= 5 years Years of service= 14 years Cash flow from 5 to 14 years = for…
Q: Phylis Ltd has the following transactions in respect of its goods during Dec 2015. Opening stock…
A: "Since you have asked multiple questions we will solve the first question for you. If you want any…
Q: The yield on 1-year Treasury securities is 6%, 2-year securitiesyield 6.2%, 3-year securities yield…
A:
Q: 5. If money can be invested at 5% compounded annually, A. Accumulate P1,000 for 15 years. B.…
A: Compound Interest in the simplest terms can be referred to as charging an interest over the simple…
Q: The following table represents sales data for milk (in hundred liters0 sold by a grocery. Do the…
A: Given data - Month Demand (In 100 Lt.) 1 39 2 47 3 39 4 44 5 49 6 48 7 45 8 56…
Q: Given these values, what type of investment strategy would be selected by the Maximincriterion?
A: Maximin: The implementation is done by taking minimum of all values first and then taking the…
Q: Right now is Quarter 2 of 2020. You are developing an aggregate production plan for 2021. Suppose…
A: Given data- Particulars Quarter 1 Quarter 2 Demand 1208 891 Regular Production 1950 891…
The general fund revenue receipts for the state of Kentucky for 2003 (period 1) to (period 15 ) follows. Do not round intermediate calculations.
Budget | ||||
Year | Period | ($billions) | ||
2003 | 1 | 6.785 | ||
2004 | 2 | 6.973 | ||
2005 | 3 | 7.647 | ||
2006 | 4 | 8.373 | ||
2007 | 5 | 8.579 | ||
2008 | 6 | 8.666 | ||
2009 | 7 | 8.428 | ||
2010 | 8 | 8.223 | ||
2011 | 9 | 8.755 | ||
2012 | 10 | 9.097 | ||
2013 | 11 | 9.301 | ||
2014 | 12 | 9.554 | ||
2015 | 13 | 9.963 | ||
2016 | 14 | 10.334 | ||
2017 | 15 | 10.474 |
A. Develop a linear trend equation for this time series. Round your answers to 4 decimals.
Tt = ____+ _____t
B. What is the
$_____billion
Step by step
Solved in 2 steps with 2 images
- Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?It is often difficult to estimate the expected future dividend growth rate for use in estimating the cost of existing equity using the DCF or DG approach. In general, there are three available methods to generate such an estimate: • Carry forward a historical realized growth rate, and apply it to the future. • Locate and apply an expected future growth rate prepared and published by security analysts. • Use the retention growth model. Suppose Johnson is currently distributing 45% of its earnings in the form of cash dividends. It has also historically generated an average return on equity (ROE) of 20%. Johnson’s estimated growth rate is %.The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $
- A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are settled as follows, in…You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
- I need help with everything, please. hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 1. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year Payment 1 190 2 215 3 240 4 285 5 315 6 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street…Kidnly answer the following and include steps: Financial planner Minnie Margin has a substantial number of clients who wish to own a mutual fund portfolio that matches, as a whole, the performance of the Russell 2000 index. Her task is to determine what proportion of the portfolio should be invested in each of the five mutual funds listed below so that the portfolio most closely mimics the performance of the Russell 2000 index. Annual Returns Year 1 Year 2 Year 3 Year 4 International Stock 22.37 26.73 4.86 2.17 Large-Cap Value 15.48 19.64 11.50 -5.25 Mid-Cap Value 17.42 20.07 -4.97 -1.69 Small-Cap Growth 23.18 12.36 3.25 3.81 Short-Term Bond 9.26 8.81 6.15 4.04 Russell 2000 Index 20 22 8 2 a. Write out the (non-linear) program that would produce a portfolio that most closely mimics the performance of the Russell 2000 Index. b. Use Excel's Solver with "GRG Non-Linear" as the solution algorithm:…Please show the steps by using the formula for each Salalah Methanol company management is considering three competing investment Projects Option1: Starting a unit in Sohar, Option 2: Starting a unit in Musandam and Option 3: Starting a unit in Muscat. The initialinvestment for all the projects are 11000 and the cost of capital is 4.05% Year Sohar Musandam Muscat 1 1100 2160 3225 2 3100 3260 4250 3 3800 4360 5475 4 4600 5460 6300 5 5100 6900 7000 Use the information below and help the management in choosing the most desirable Project using a. Payback period b. Discounted payback c. Net Present value d. Profitability Index. You have to suggest to the management which project to choose and why