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

You are called in as a financial analyst to appraise the bonds of Olsen's Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 10 percent, which is paid semiannually. The yield to maturity on the bonds is 12 percent annual interest. There are 25 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the bonds based on semiannual analysis. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Bond price b. With 20 years to maturity, if yield to maturity goes down substantially to 8 percent, what will be the new price of the bonds? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) New bond price

i need the answer quickly

BlueLtd. Issued a $1,164,000, 10-year bond dated January 1, 2020. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Blue followed IFRS. Using 1 factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond. Click here to view the tactor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITYOF 1 (For calculation purposes, use 5 decimal places as displayed in the factor table provided and final answers to 0 decimal places, e.g. 5,275.) Proceeds from sale of bond : on bond Prepare the journal entries for above transactions. (Round answers to 0 decimal places, e.g. 5,275. Credit account titles are automatically indented when the amount is entered. Do not Indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the…

Ticker Services began operations in Year 1 and holds long-term investments in available-for-sale debt securities. The year-end cost and fair values for its portfolio of these investments follow. Portfolio of Available-for-Sale Securities December 31, Year 1 December 31, Year 2 Cost $ 13,000 20,000 23,000 16,500 December 31, Year 3 December 31, Year 4 Complete this question by entering your answers in the tabs below. Prepare journal entries to record each year-end fair value adjustment for these securities. Adjustment General Journal Calculation Calculation adjustment required to fair value adjustment. 12/31/Year 1 Existing balance in Fair Value Adjustment-AFS (LT) Required balance in Fair Value Adjustment-AFS (LT) Adjustment required to Fair Value Adjustment-AFS (LT) 12/31/Year 2 Existing balance in Fair Value Adjustment-AFS (LT) Required balance in Fair Value Adjustment-AFS (LT) Adjustment required to Fair Value Adjustment-AFS (LT) 12/31/Year 3 Existing balance in Fair Value…

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Video Excel Online Structured Activity: Bond valuation An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 9.1%. Bond C pays a 10.5% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Assuming that the yield to maturity of each bond remains at 9.1% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent. Years to Maturity Price of Bond C Price of Bond Z 4 3 $ $ 2 $ 1 $ $ Check My Work Reset Problem

Excel Online Structured Activity: Bond valuation An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity of 9.4%. Bond C pays a 10% annual coupon, while Bond Z is a zero coupon bond. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.     Open spreadsheet   Assuming that the yield to maturity of each bond remains at 9.4% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Do not round intermediate calculations. Round your answers to the nearest cent.   Years to Maturity Price of Bond C Price of Bond Z 4 $  fill in the blank? $  fill in the blank?  3 $  fill in the blank? $  fill in the blank?  2 $  fill in the blank?  $  fill in the blank?  1 $  fill in the blank? $  fill in the blank? 0 $  fill in the blank?  $  fill in the…

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…

Please see below. Need this asap please and thank you.