Please include the excel formula   Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.7 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 5.05 percent. What is the dollar price of the bond? Input area:                                   Settlement date 1/1/2020               Maturity date 1/1/2033               Coupon rate 4.70%               Coupons per year 2               Redemption value (% of par) 100               Yield to maturity 5.05%               Par value  $2,000                                  (Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the “Basis” input blank in the function. You may enter a constant as a hard coded value.)                                                     Output area:                                   Price (% of par)                 Price

Q: Melvin Indecision has difficulty deciding whether to put his savings in Mystic Bank or Four Rivers…

A: The compound interest adds the interest earned in a period to the principal because of which more…

Q: A stock has a beta of 1.3, the expected return on the market is 11 percent, and the risk-free rate…

A: The Capital Asset Pricing Model (CAPM) refers to the model which tells us how the financial markets…

Q: Select the type of risk that is most evident in the pairings. Investments in Junk Bonds VS…

A: Business risk is a risk that the company will not be able to achieve its financial target. SO risk…

Q: Thiewes Corp has an expected dividend of $ . 1 75, k 13 percent, and g 7 percent. Based on the…

A: Constant growth Model calculates the price now when the expected cash flow or dividend for the next…

Q: To establish a revenue stream for your retirement, you deposit $89000 in an account with a nominal…

A: Information Provided: Initial Deposit = $89,000 Monthly payments = $311.50 Interest rate = 4.20%…

Q: Question 1 a) Which are the top 3 countries in terms of projected annual revenue (state them in…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: If you invest $10,000 per year at the end of each year for 3 years at an 5.5% rate of return, you…

A: Future Value of anuity = P * [ { (1 + r )n -1 } /r ] where, P =  periodic payment r = interest rate…

Q: If Php10,568 is the proceeds obtained after Php13,500 is discounted for 10 months, what is the…

A: We have the discounted proceed from an original proceed. We need to calculate the discount rate.

Q: buy a house of $500,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of…

A: Loans are paid by the monthly payments which are equal fixed payments but the payment of interest…

Q: Assume that you can invest in any of the following three securities today. You will hold them for a…

A: Probability of "state" Stock A Stock B S&P 500 1/3 19% 0% 5% 1/3 3% 12% 10% 1/3 23% 20%…

Q: just to make sure: in order to calculate the expected return of stock in our case the Rm is 7% or…

A: Formula for E(R) = Risk-free rate(Rf) + Beta of the stock x (Market Return(Rm) - Risk free rate(Rf))

Q: Question 10 If the nominal rate in compound interest is 10% compounded semi-annually, what is the…

A: Interest rate = 10% Number of compounding per year = 2

Q: ompany aaa wishes to give each 25 employees a christmas bonus how much is needed to invest monthly…

A: The future value of money includes the amount needed is amount that is being deposited and amount of…

Q: Dingo Corp is planning to pay out an annual dividend of $7 in perpetuity starting 8 years from now.…

A: Annual dividend (D) = $7 Required return = 0.052 or 5.2   First we will calculate effective annual…

Q: Stephanie Carter has been gifted a sum of $50,000 by her grandparents on completing her graduation…

A: Future Value: The value of an investment at the end of its invested period or at some point of time…

Q: Suppose you invest $8,000 in a mutual fund in one year and $9,500 in two years. If the fund pays 7%…

A: Investment The process of investing money in financial assets in order to get a return is called…

Q: Metallica Bearings, Incorporated, is a young start-up company. No dividends will be paid on the…

A: Dividend discount model (DDM) is used to detrmine the intrinsic price of the stock after discounting…

Q: An Ireland economy with two opposing factions: the Belgium and the Germany. There is one bank, the…

A: We have to find the price of a bond likely to be defaulted, from the perspective of an investor. We…

Q: A consumer has preferences over 3 goods represented by the utility function

A: Solution: Given: u = (x1x2 )0.5 - 2-x3  MUx1 = 0.5 (x2 / x1 )0.5  MUx2 = 0.5 (x1 / x2 )0.5  MUx3 =…

Q: 2. Future Value: FV = PV(1+r)" a) P10,600 invested at 12% compounded semi-annually for 5 years b)…

A: As per our guidelines, we are supposed to answer only 3 sub-parts (if there are multiple sub-parts…

Q: Payments of P 10,000 per quarter are made from June 7 through Z through December 7, Z + 11…

A: The current value of a future sum of money or stream of cash flows at a predetermined rate of return…

Q: Isn't the final payment going to be $144.78? How did you get final payment of $138.51

A: Table showing the final payment: Snapshot:

Q: Find the interest rate per conversion period (i) and the total conversion periods (n) at the end of…

A: Several instances of annual interest rates being compounded at various frequencies have been given.…

Q: What are the expected return and standard deviation of your client's portfolio?

A: Given, expected rate of return of 19% standard deviation of 30% The T-bill rate is 4%.

Q: What is a bond? What are some features of a bond? How do you value bonds? What factors can affect…

A: Bond is one of the most used debt instruments that are used both by private and government…

Q: A company offers your friend, Lily, an interesting gamble involving giving her u choice of the…

A: There are many types of the investors some prefer risk and some do not like risk and some enjoy risk…

Q: A plant erected to manufacture sock has a first cost of P10,000,000.00 with an estimated salvage…

A: A method for depreciating an asset while earning enough cash to replace it when its useful life is…

Q: WHY DO YOU THINK SOME P/E RATIOS OF STOCKS ARE LOWER THAN OTHERS?

A: We have to explain why SOME P/E RATIOS OF STOCKS ARE LOWER THAN OTHERS. We need to understand what a…

Q: What makes indirect benefits so difficult to include in a BCA? What techniques might be used?

A: Indirect benefits are those benefits the return of which cannot be directly observed. Moreover, such…

Q: 1.    The Viking Company is preparing budgets for the second quarter ending June 30.  Last year's…

A: As per the Honor code of Bartleby we are bound to given the answer of first three sub part only,…

Q: Stag Company will pay dividends of $9.6, $5.9, $9.7 and $10 for the next four years. Thereafter, the…

A: To Find: Current market price of the share

Q: excelo inc. just purchased a new machine for $85000. the machine will generate savings of $25000 per…

A: The initial cost and the salvage value of a machinery is known. We have to find the equivalent…

Q: Casa Chica is considering replacing a piece of equipment. Alternative A costs $80,000, has an eight…

A: Given, Cost of Alternative A is $80,000 Cost of alternative B is $65,000

Q: As a financial consultant, you are given the following information about two companies, one levered…

A: Concept. 1.Value of firm = net income ÷ cost of capital(WACC) 2. Value of firm  = value of debt +…

Q: Problem #2 Temporary Employee Time Card Name: Eugene Mueller Dept: Sales Note: No Overtime Rate…

A: Gross pay is the total amount earned by the employee for the time he worked. It also includes…

Q: Investment corporation in a matured industry in a corporation in a new industry vs Investment in O…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: uppose that Nintendo Co., Ltd. (NTDOY) is currently trading at $180 per share. Mark buys 200 shares,…

A: Brokers provide margins to client for trading and so that they can trade more and so that client and…

Q: Find their regular monthly payment. (Round your answer to the nearest cent.) $ (b) Find the unpaid…

A: Information Provided: Loan amount = $125,000 Interest rate = 7.8% compounded monthly Period for…

Q: Tony Ring wants to attend Northeast College. If he deposits $52,087 today, how much will he have 5…

A: Information Provided: Present value = $52,087 Interest rate = 6% compounded semiannually Period = 5…

Q: Solve the problem. Monthly Payment per $1000 of Mortgage Interest 15-year rate loan 9.5% $10.45…

A: Monthly Interest can be computed as follows = (Principe x Rate of Interest x 1) /(100 x 12) Since we…

Q: 5) Consider a retirement savings account where the monthly contribution is $125 for the first 10…

A: Monthly contribution for first 10 years is $125 Monthly contribution for next 25 years is $225…

Q: Metallica Bearings, Incorporated, is a young start-up company. No dividends will be paid on the…

A: Value of the stock at the end of 9 years = D10(r-g) Where, D10 is dividend per share 10 years from…

Q: ABC Corporation plans to issue a 9%, 10-year, P5,000,000 face value bonds. It will incur P500,000 as…

A: Yield to maturity is rate of return realized on the bond when bond is held till the maturity period…

Q: You just bought a new luxury sports car for $125,000. Before you had time to get insurance, the car…

A: We must look at this situation from a cost point of view. How much is each option going to cost. Now…

Q: The Johnson Family borrowed $3,000 for 18 months at 4% interest. What is the total payback on the…

A: Future value refers to the value of the current asset at some future rate on the basis of…

Q: Ratios Current Ratio Quick Ratio Receivable Turnover Inventory Turnover Debt Ratio Return on Assets…

A: Concept. Financial ratios of the company are used by lenders and investors for making decisions with…

Q: Lorenzo and Carlotta have three children (ages 5, 6, and 14), Lorenzo earned $36,000 in 2020.…

A: Given: In this question, the given details are Lorenzo and Carlotta have three children ( ages 5, 6…

Q: hat is the monthly investment amount required to generate a corpus of 10000000 in 8 years at return…

A: Future value of investment includes the amount being deposited and amount of interest accumulated…

Q: Given the following probability distributions, what are the expected returns for the Market and for…

A: We will calculate probability weighted return for both the returns i.e. market return and security J…

Q: The stated interest rate on your account is 8%, interest compounded monthly. If you deposit $50 each…

A: Future Value Annuity is the technique of determining the furure value of a series of regular…