Excel Online Tutorial Excel Online Structured Activity: Bond valuation You are considering a 10-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 11.68%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent.
Q: Required information A potential investment has a cost of $425,000 and a useful life of 5 years.…
A: Annual cash inflows are the cash inflows incurred during the year for the purpose of calculating the…
Q: CAN U PLEASEE PLEASE PLEASE HELP ME WITH THISS 21. A bank recently loaned $18,204.00 to buy a car.…
A: Present Value is the Cumulative Value of interest and Principal being paid in instalments at future…
Q: Give only typing answer with explanation and conclusion Consider an eight-month European put option…
A: An option is a type of financial instrument that is based on the value of underlying securities,…
Q: Helga is considering the purchase of a small restaurant. The purchase price listed by the seller is…
A: Present value is the current value of future value cash flows at specified interest rate. Present…
Q: . If there are 30 million shares outstanding, what is the net asset value? b-1. If a large…
A: We can determine the NAV using the formula below: NAV = Portfolio Value - LiabilitiesNumber of…
Q: Rework Table 74 for horizon years 1, 2, 3, and 10, assuming that investors expect the dividend and…
A: Given: Particulars Dividend paid $6.00 Expected return 12% Growth rate 6%
Q: From the following facts, complete a depreciation schedule by using the straight-line method: Note:…
A: The depreciation of an asset refers to the reduction in the book value of the asset throughout its…
Q: Accounts Notes Payable Accounts payable Cost of goods sold Other expenses Interest Depreciation Cash…
A: Operating cash flow refers to the measurement of cash generated from the business activities for…
Q: Suppose today is January 1, 2024 and you are given two options: a. an annuity that pays you 1000…
A: Annuity is fixed amount being paid at each year for the fixed period of time Perpetuity is fixed…
Q: The maturity value of a $44000, 9%, 60-day note receivable dated July 3 is O $44000. O $51920. O…
A: Maturity value = Present value/issued price + interest accrued for 60 days
Q: Bramble Corporation had net credit sales of $14100000 and cost of goods sold of $9370000 for the…
A: Inventory turnover helps in understanding how many times the inventory has been sold, or replaced in…
Q: What is the future value of a 9%, 5-year ordinary annuity that pays $450 each year? Do not round…
A: The formula used to calculate future value of annuity is FV of ordinary annuity = Pmt*((1+r)n-1 )/r…
Q: You are a consultant to a large manufacturing corporation considering a project with the following…
A: Expected return as per CAPM = (Rf+ Beta * (Market risk premium)) The CAPM return is a theoretical…
Q: OptiLux is considering investing in an automated manufacturing system. The system requires an…
A: Internal Rate of Return is the rate of return where present value of cash inflows is equal to…
Q: 1. There are two mutual funds, A and B with the following information, R₁ Security The Market The…
A: CAPM refers to the relation between the expected return of a stock to the risk associated with the…
Q: Below are information relating to three (3) possible projects. Evaluate the projects by filling up…
A: Capital budgeting refers to the method used for estimating the viability of the project using the…
Q: mpany has $2.5 million of sales today, SG&A costs of $2 million excluding depreciation, annual…
A: Break even point is where all cost are covered including variable cost and fixed cost and there is…
Q: Give typing answer with explanation and conclusion you want to borrow $71,400 from your local bank…
A: The idea of the time value of money (TVM) holds that a quantity of currency is valuable currently…
Q: If a business unit generated $3,600,000 in BEFORE TAX PROFIT and had invested capital of $18,000,000…
A: An indicator of the financial success of ongoing initiatives, Economic Value Added (EVA), also…
Q: M-e-r-ge-r- -F-u-n-d-a-m-e-n-t-a-l-s M-o-t-i-v-e-s- -f-o-r- M-e-r-g-i-n-g G-r-o-w-t-h- - o-r-…
A: Dear Student, As per answering guidelines, I am providing solution of first 3 subparts. Strategic…
Q: Using either logarithms or a graphing calculator, fnd the time required for each initial amount to…
A: Principal = $4500 Annual interest rate = 3.6% = 0.036 Number of compounding periods per year =12…
Q: Consider the Following 10-year project: Year Cash Flow 0 -30000 1 2500…
A: Net present value (NPV):The net present value is a technique used for making the investment…
Q: A sailboat costs $22,765. You pay 15% down and amortize the rest with equal monthly payments over a…
A: EMI is also known as monthly payment. It includes the Interest amount & principal amount which…
Q: Problem 11-6 Risk Premiums (LO1) Assume these are the stock market and Treasury bill returns for a…
A: Years Stock Market return T-Bill Return 2016 35.40% 0.19% 2017 14.80% 0.19% 2018 -4.70% 0.19%…
Q: A stock increased in value 400% over the past 4 years. This was an increase of $1,200. What was the…
A: Data given: Increase in value over the past 4 years=400% Increase amount=$1200 Required: a) Value…
Q: Ivanna is leasing a car originally valued at $37,010. The lease is being financed with an interest…
A: Monthly payments carry the payment for interest and also payment for lease payments also and these…
Q: Use graphical approximation techniques or an equation solver to approximate the desired interest…
A: The annual nominal rate refers to the stated or nominal interest rate charged or earned on a…
Q: 4. Jasmine finished reading a book in 5 days. She read of of the book on Monday. She read 1 of the…
A: First we need to calculate ratio of all 5 days, thereafter total pages can be calculated by choosing…
Q: Arvin's is analyzing a project with an initial cost of $212,000 that would be depreciated…
A: In breakeven analysis Financial Breakeven is the point of sale where all cost are covered by the…
Q: Chris Seals has just given an insurance company $62,525. In return, she will receive an annuity of…
A: Investment amount (PV)=$62,525 Annuity amount (PMT)=$7,458 Time period (N)=12 years Future value=$0…
Q: Problem 11-1 Stock Market History (L01) Use the data in the tables below to answer the following…
A: Businesses examine possible significant projects or expenditures using the capital budgeting…
Q: How specifically can it be argued that integrating internet technology into a company's operations…
A: Integrating internet technology into a company's operations can have a significant impact on process…
Q: A closed-end fund starts the year with a net asset value of $27. By year-end, NAV equals $28.60. At…
A: Information Provided: Beginning NAV = $27 Ending NAV = $28.60 Beginning NAV Premium = 2% Ending NAV…
Q: Imagine a particular security’s default risk premium is 2 percent. For all securities, the inflation…
A: The equilibrium rate of return is to be calculated by adding the beta and risk-free rate of the…
Q: 1. A man was offered a landbank certificate with a face value of P 100,000 which is bearing an…
A: Here, Face Value of Certificate is P100,000 Coupon Rate is 6% Required Rate of Return is 8%…
Q: Fifteen years ago, the Budai family bought a home and financed $150,000 with a 30-year mortgage at…
A: No. of years = 30 Interest Rate = 8.2% Financed Amount = $150,000 Compounded = Monthly Monthly rate…
Q: A $1500 treasury bond with a coupon rate of 3.1% that has a market value of $1350. What is the…
A: Data given: Face value=$1500 Coupon rate=3.1% Current market value=$ 1350 Required: Current yield…
Q: The standard factor equation that would answer the question
A: Future value With interest or discount rate (r), period (n) and present value, the future value is…
Q: Vick incorporated sold bonds on January 1, 2005. The bonds were 15 year bonds with a 4% coupon. The…
A: Period of bonds = 15 years Coupon rate = 4% Market interest rate = 5% Terminal value = 1000
Q: You wish to buy a $20,000 car. The dealer offers you a 6-year loan with a 7.2 percent APR. What are…
A: The borrower can pay interest at regular intervals or at the time of making payment. The payment…
Q: Calculate the missing information for the purchase. Sales Tax Rate Item Book Selling Price (in $)…
A: Purchase price after sales tax Purchase price = Selling Price *(1+r)
Q: The actual cost of a material is $2.33 per produced unit. A Six sigma team develop a productivity…
A: Internal rate of return refers to the method of capital budgeting used for computing the minimum…
Q: ing investing in a project that will cost $160,700 and have no salvage value at the end o s…
A: Annuity is a series of equal payment at equal interval for a specified period. Present value of…
Q: Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net…
A: Data given: Reported Forecast Horizon Period Terminal Period Particulars 2018 2019 2020 2021…
Q: a. What is the average expected return, r, for each asset over the 3-year period? b. What is the…
A: Please note that under the answering guidelines only up to 3 subparts can be solved. Kindly repost…
Q: Using a compound interest calculator, if you would deposit $10 each week into a savings account that…
A: Deposit = $10 Interest rate = 3.75% compounded monthly Period = 5 years
Q: A portfolio contains two stocks: Luckin Stock and Gold Stock. Luckin Stock accounts for 70% of the…
A: Expected return is simply the average of all the returns provided. Standrad deviation is the…
Q: A French company is considering a project in US. The project will cost $100M. The cash flows are…
A: In this question, the home currency is € and the foreign currency is $. We need to convert the cash…
Q: How much would $300 invested at 4% interest compounded monthly be worth after 8 years? Round your…
A: Compound = Monthly = 12 Present Value = pv = $300 Interest rate = r = 4 / 12 % Time = t = 8 * 12 =…
Q: New-Project Analysis The president of your company, MorChuck Enterprises, has asked you to evaluate…
A: Net Present value is the determination of present value of future cash flow when discounted with…
Finance
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
- a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it be if there were only 9 or 8 years to maturity? Use the worksheet to compute the bond issue prices and enter them in the spaces provided. Bond issue price (9 years to maturity) __________________ Bond issue price (8 years to maturity) __________________ b. Compare these prices to the bond-carrying values found in the effective interest amortization schedule you originally printed out in requirement 3. Explain the similarity. c. Click the Chart sheet tab. The chart presented shows the price behavior of this bond based on years to maturity. Explain what effect years to maturity has on bond prices. Check your explanation by trying 8% as the effective rate (cell E10) and clicking the Chart sheet tab again. Also try 9%. When the assignment is complete, close the file without saving it again. Worksheet. Modify the BONDS3 worksheet to accommodate bonds with up to 20-year maturity. Use your new model to determine the issue price and amortization schedules of a 2,000,000, 18-year, 10% bond issued to yield 9%. Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as BONDST. Hint: Expand both amortization schedules to 20 years. Expand the scratch pad to 20 years. Modify FORMULA1 in cell F17 to include the new ranges. Chart. Using the BONDS3 file, prepare a line chart that plots annual interest expense over the 10-year life of this bond under both the straight-line and effective interest methods. No Chart Data Table is needed. Put A23 to A32 in the Label format and then select A23 to A32, D23 to D32, and B40 to B49 as a collection. Enter all appropriate titles, legends, formats, and so forth. Enter your name somewhere on the chart. Save the file again as BONDS3. Print the chart.Bond Valuation with Semiannual Payments Renfro Rentals has issued bonds that have a 10% coupon rate, payable semiannually. The bonds mature in 8 years, have a face value of $1,000, and a yield to maturity of 8.5%. What is the price of the bonds?Excel Online Structured Activity: Bond valuation You are considering a 15-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 10.42%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ fill in the blank ? here is the reference,
- 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…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 8.3%. 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. Assuming that the yield to maturity of each bond remains at 8.3% 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 $ $ 0 $ $(Bond Valuation Problem) A $1,000 par value bond with a coupon interest rate of 12.8 percent per year paid semiannually matures in 25 years. Draw a CF diagram corresponding to this information and then complete the table below by filling in the prices and YTMs that correspond to the given YTM’s and prices respectively. Show all the work for part D – both the PVAt and PV calculations. Then check your answer using your calculator’s TVM solver menu or function keys. PRICE YTM A. ______________ ___0%____ B. __$1,000______ __________ C. __$ 917.19_____ __________ D. ______________ ___16%____ Step By Step explanation please, I need to be able to see how we arrived at the answers as if I was writing them on a sheet of paper.
- 1. (Bond Valuation Problem) A $1,000 par value bond with a coupon interest rate of 12.8 percent per year paid semiannually matures in 25 years. Draw a CF diagram corresponding to this information and then complete the table below by filling in the prices and YTMs that correspond to the given YTM’s and prices respectively. Show all the work for part D – both the PVAt and PV calculations. Then check your answer using your calculator’s TVM solver menu or function keys. PRICE YTM A. ______________ ___0%____ B. __$1,000______ __________ C. __$ 917.19_____ __________ D. ______________ ___16%____ou are considering a 30-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 11.29%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ fill in the blank 2create an excel file A 200,000 10-year bond pays coupon annually at a rate of 6% semiannually. The bondis bought to yield 5% semiannually at par. Construct an amortization schedule for thisbond which includes all the given information, an entry for the price of the bond whichreflect the formula used to generate its value, and the table of amortization.
- Question A .Your company currently has $1,000 par, 6.25% coupon bonds with 10 years to maturity and a price of $1,071. If you want to issue new 10-year coupon bonds at par, what coupon rate do you need to set? Assume that for both bonds, the next coupon payment is due in exactly six months. You need to set a coupon rate of _ % (Fill in the _) Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line(Bond valuation) Enterprise, Inc. bonds have an annual coupon rate of 14 percent. The interest is paid semiannually and the bonds mature in 13 years. Their par value is $1,000. If the market's required yield to maturity on a comparable-risk bond is 8 percent, what is the value of the bond? What is its value if the interest is paid annually? Question content area bottom Part 1 a. The value of the Enterprise bonds if the interest is paid semiannually is $enter your response here. (Round to the nearest cent.) Part 2 b. The value of the Enterprise bonds if the interest is paid annually is $enter your response here. (Round to the nearest cent.)Finance eBook Problem Walk-Through 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 8.6%. Bond C pays a 12.5% annual coupon, while Bond Z is a zero-coupon bond. Assuming that the yield to maturity of each bond remains at 8.6% over the next 4 years, calculate the price of the bonds at each of the following years to maturity. Round your answers to the nearest cent. Years to Maturity Price of Bond C Price of Bond Z 4 $ $ 3 $ $ 2 $ $ 1 $ $ 0 $ $ Select the correct graph based on the time path of prices for each bond. The correct sketch is