or the data set Download data set, perform a 3 month moving average to determine the forecast for month 13 (click on the arrow to download the file). Be sure to label the forecasted value for month 13. You must show all work in an Excel file and upload the Excel file. Corporate triple A bond interest rates month rate 1 9.5 2 9.3 3 9.4 4 9.6 5 9.8 6 9.7 7 9.8 8 10.5 9 9.9 10 9.7 11 9.6 12 9.6

or the data set Download data set, perform a 3 month moving average to determine the forecast for month 13 (click on the arrow to download the file). Be sure to label the forecasted value for month 13. You must show all work in an Excel file and upload the Excel file. Corporate triple A bond interest rates month rate 1 9.5 2 9.3 3 9.4 4 9.6 5 9.8 6 9.7 7 9.8 8 10.5 9 9.9 10 9.7 11 9.6 12 9.6

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 12P: Corporate triple A bond interest rates for 12 consecutive months are as follows: Construct a time...

See similar textbooks

Similar questions

Corporate triple A bond interest rates for 12 consecutive months are as follows: Construct a time series plot. What type of pattern exists in the data? Develop three-month and four-month moving averages for this time series. Does the three-month or the four-month moving average provide the better forecasts based on MSE? Explain. What is the moving average forecast for the next month?
Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.) AmountFinanced Number ofPayments APR TableFactor FinanceCharge MonthlyPayment $7,900 36 10% $ $ $ https://www.webassign.net/brecmbc9/13-table-1.pdf
3. Assume you purchased a bond for $9,186. The bond pays $300 interest every six months. You sell the bond after 18 months for $10,000. Calculate the following: a. Income. b. Capital gain (or loss). c. Total return in dollars and as a percentage of the original investment. Review Only Click the icon to see the Worked Solution. a. The current income is $ (Round to the nearest dollar.) b. The capital gain (or loss) is $ (Enter a loss as a negative number and round to the nearest dollar.) c. The total return in dollars is $ (Round to the nearest dollar.) The total return as a percentage of the original investment is %. (Enter as a percentage and round to two decimal places.)
The following information should be used for questions 8, 9 and 10. Plan accordingly to save time. A Collateralized Mortgage Obligation (CMO) principal balance is $1,000,000,000. The pass thru rate is 5.35%. The Weighted Average Coupon rate is 6.35%. The weighted Average Months is 350. The PSA is 90. The CMO (at the time the CMO is first created) is divided into 4 tranches (A,B,C,D), each with a par value of $250,000,000 and 5.35% coupon rate. Within how many months from the creation of the CMO will tranche C principal be totally paid? Group of answer choices a)30 b)55 c)207 d)350
Tab Window Hélp sponse The balance of an interest-bearing account can be modeled by an exponential equation. For example, consider an initial deposit of $2000 at an annual interest rate of 6%. The interest earned each year is deposited into the account at the end of the year. A. Assuming that no withdrawals or deposits are made, write an equation that models the account balance after x years. Your answer B. What is the account balance at the end of the 10 years? Your answer C. Create a graph that shows the increase in the account balance over the next 20 years, including your initial deposit. Your answer D. Using the graph, estimate how many years it will take for the initial deposit to double. Your answer E. If you deposited $2000 in an account of this type, what would the account balance be when you are 45 years old assuming that you are 18 years of age right now?
The balance of my Target credit card is $854.56 with an APR of 28%. What are my finance charges for the month of April?
Real-Time Data Analysis Exercise Click the following link to view interest rate data from FRED*. Then use that data to answer the following questions. *Real-time data provided by Federal Reserve Economic Data (FRED), Federal Reserve Bank of Saint Louis. Using the data from FRED, enter the values for the interest rates indicated for the date shown below. (Enter your responses exactly as they appear in FRED.) Series Series ID Apr 2023 4.68 % 3.76 % 1-Year Treasury Constant Maturity Rate 3-Year Treasury Constant Maturity Rate 5-Year Treasury Constant Maturity Rate 10-Year Treasury Constant Maturity Rate 20-Year Treasury Constant Maturity Rate 30-Year Treasury Constant Maturity Rate According to the table above, interest rates are expected to GS1 GS3 GS5 GS10 GS20 GS30 3.54 % 3.46 % 3.80 % 3.68 % O A. fall significantly in the future because the yield curve is inverted. B. rise in the future because the yield curve is relatively flat. C. rise in the future because the yield curve is…
A borrower has two alternatives for a loan: (1) issue a $570,000, 90-day, 7% note or (2) issue a $570,000, 90-day note that the creditor discounts at 7%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. (1) $570,000, 90-day, 7% interest-bearing note: $ (2) $570,000, 90-day note discounted at 7%: $ c. Alternative is more favorable to the borrower because the borrower
Assume that a bond will make payments every six months as shown on the following timeline (using six-month periods): The timeline starts at Period 0 and ends at Period 20. The timeline shows a cash flow of $ 20.72 each from Period 1 to Period 19. In Period 20, the cash flow is $ 20.72 plus $ 1,000. Period0121920 Cash Flows$20.72$20.72$20.72$20.72+$1,000 a. What is the maturity of the bond (in years)? b. What is the coupon rate (as a percentage)? c. What is the face value?
Suppose your MasterCard calculates interest using the average daily balance method, and the monthly interest rate is 1.9%. The itemized billing for the month of August is shown below The average daily balance has already been computed and is $2739.52. (a) Find the interest due for this month. $ (b) Find the total balance owed on the last day of the billing period. $ (c) This credit card requires a $15 minimum payment or 1/24 of the amount due, whichever is higher. What is the minimum monthly payment due for this month? $
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using the Present Value Tables. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C3” was entered, the formula would output the result from cell C3, or $500,000 in this example. Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation…
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using the Present Value Tables. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C3” was entered, the formula would output the result from cell C3, or $500,000 in this example. Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation…