What's the equation and answer in excel?

Q: What will be the future value of $5 000 invested for six years at 8% per annum compounded quarterly

A: Formula for finding the future value is P(1+i/4)^(t*4) P = $5000, i= interest = 8% , t = time = 6

Q: Finance A sales associate was issued by his initial Florida sales associate license last year. The…

A: Given: A sales associate was issued by his initial Florida sales associate license last year. The…

Q: Question: BRICS Company has a beta of 0.8. The risk-free rate is equal to 3% and the expected market…

A: Expected return is calculated under CAPM is also called KE ( Cost of equity). It is that which was…

Q: Jacqueline purchased a machine for $25,000 for his company. He paid 5.00% of this amount as a down…

A: We know that if any down payment is made in the beginning then such an amount will be reduce from…

Q: The market price of TRUST bond is currently $890. Its par value is equal to $1,000 and it is…

A: Bond: These are fixed-income securities that reflect loans from investors to borrowers . A bond can…

Q: What is X in the formula: FV = X(1+r) ?

A: This relates to the concept of time value of money. As per the concept of time value of money to…

Q: ​(Floating-rate loans)  The Bensington Glass Company entered into a loan agreement with the​ firm's…

A: LIBOR:-London Interbank Offer Rate. The interbank market's benchmark rate for unsecured short-term…

Q: Kim Epson operates a full-service car wash, which operates from 8AM to 8 PM seven days a week. The…

A: The payback period is the measure of the ability of an investment to cover its costs. An investment…

Q: Beta is useful in practice because it assists in: Select one: a.   designing portfolios suited to…

A: A stock's volatility can be compared to the systematic risk of the entire market using a beta…

Q: Stinson Corporation borrowed $85,000 at 8% compounded quarterly to buy a warehouse. Monthly payments…

A: Here, To Find: Amortization schedule showing last 2 payments =? Total amount paid to settle the…

Q: 21. A bond makes an years before maturity, where it will pay 1000. 22. Kaskad is selling at 20 per…

A: The Gordon Growth Model is a model used to price a company's stock based on the dividends the…

Q: ABC corporation bonds have a coupon rate of 8% paid semiannually and 30 years to maturity. If the…

A: Solution:- Bond price means the price at which the bond is currently trading in the market. It is…

Q: A furniture company allows customers to purchase household furnishings with an in-store loan, pay…

A: Rent-to-own is a system where the customer buys furniture on installment payment basis and enters…

Q: The par value of 10% debenture is $1,000 with maturity is 3 years. What would be the price if…

A: Data given: Coupon rate = 10% Par value = $1000 n= 3 years Required: Price if interest rate is a)…

Q: Based on the following information, what is the highest pr willing to pay for Bank D? Bank A Bank B…

A: P/E ratio used for the comparison between the similar types of companies and P/E ratio must be same…

Q: You have started a company and are in luck-a venture capitalist has offered to invest. You own 100%…

A: a. Implied price per share = Amount offered / Number of shares offered

Q: You are considering making an $80,000 investment in a process improvement project. Revenues are…

A: The future worth analysis is used to find the value of an investment at a later date, taking into…

Q: Economy will improve vastly next year, and that many freight customers will gradually switch from…

A:

Q: Using the data in the table below, find the change in the Herfindahl-Hirschman index if Microsoft…

A: where Si = Market share of firm

Q: roblem 4. You have a $600,000 mortgage on a 20 year amortization with a 2.55% interest rate,…

A: Loans are to be paid by the monthly payments and these payments carry the payment for the principal…

Q: Dream Company leased equipment for its nine-year economic life, agreeing to pay P500,000 at the…

A: Answer -    As per IFRS 116 lease - lease liability is calculated on commencement date of Lease i.e…

Q: ABC Corporation acquired 100 ounces of gold as a long-term investment. The total amount invested is…

A: Rate of return is an important metric in finance. We use the rate of return percentage to determine…

Q: our yield to maturity on the Abner bonds is _____​%.​(Round to two decimal​ places.)

A: Information Provided: Years to maturity = 16 Coupon Interest Rate = 12% Bond price = $800 Par Value…

Q: You are making a proposal to start a corporation that would require invested capital of P9,000,000…

A: Invested capital = P9,000,000 Annual earnings = P1,500,000 Interest Rate = 8% Required Rate of…

Q: Rej Averion borrowed P50,000.00 from Social Security System, in the form of calamity loan, with…

A:

Q: The following are quotes for four currencies with the quote in terms of US dollars per unit.…

A: Foreign Currency Exchange: The price of the domestic currency relative to another currency is…

Q: Your company has earnings per share of $3. It has 1 million shares outstanding, each of which has a…

A: Given: Particulars Your company Target Co. Earnings per shares $3 $3 Shares outstanding 1 1…

Q: Use the option data from the table to determine the rate Buffin would have paid if it had issued…

A: The yield on the debt is defined as the rate of return that is expected by an investor to earn on…

Q: Thornton borrowed $250,000 at a rate of 7.25%, simple interest, with interest paid at the end of…

A: Simple interest is simple interest that means there is interest on the principal amount only and…

Q: Barry wishes to compute the beta of a stock that has a correlation of 0.64 with the market. The…

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

Q: What is Jane's realized rate of return for the year from the stock? Answer as a percentage, 2…

A: Information Provided: Purchase price = $58.80 Dividend per share = $1.12 Selling price = $52.33

Q: A new investment opportunity for you is an annuity that pays $1,100 at the beginning of each year…

A: The maximum amount to be paid for annuity can be calculated by discounting future cash inflows at…

Q: a loan of 10,000 is to be repaid during 4 years with equal monthly payment of P. the nominal…

A: Loan amount              10,000.00 Time Period 4 1st Year Interest Rate 2% 3 year Interest…

Q: What is the price of the following bond? years face value: maturity: coupon rate: discount rate:…

A: Face value or maturity value (MV) = $1,000 Maturity period (m) = 50 years Coupon rate = 0.10 Annual…

Q: s it still beneficial for a person to have an insurance policy? Explain your answer in detail.

A: Insurance Policy - It is a written document between the insurer and policy holder. In which insurer…

Q: As the result of an unsolicited application, a large downtown hospital has offered you a position as…

A: Employees are paid each week based on hourly rate and they are paid for extra money for overtime but…

Q: .If $1000 is deposited at 12.5% p.a. for one year, what is the effective annual interest rate if…

A: Given, The amount deposited is $1000 The annual rate is 12.5%

Q: Jenna earns an average bi-weekly net pa $1,131.00. Which compound inequality correctly shows the…

A: Budget for medical spending depends on the monthly income and should be based on that and should be…

Q: If you deposit ​$3,500 today into an account earning an annual rate of return of 11 ​percent, what…

A: Deposit today (P0) = $3,500 Annual rate of return (i) = 0.11 Period (p) = 40 years Account worth in…

Q: Robertson Resorts is considering whether to expand their Pagosa Springs Lodge. The expansion will…

A: The question is related to capital Budgeting. The the annual net operating income is calculated with…

Q: The current market value of a firm’s share is $32 million, with 20 million shares outstanding. The…

A: The price to earning valuation model is a model for determination of value of company on the basis…

Q: onto 45. Bill borrowed PHP 10,000 from Mr. Will on July 11, 2018 and promised to pay it by December…

A: The question is related to the simple Interest. The Simple Interest is calculated with the help of…

Q: Use your critical thinking and reasoning skills to solve the following problem.   Bob loves…

A: Step I: Bob's requirement : i) Pair of jeans that costs RM 95.00 ii) Other  requirements: a) New…

Q: How much interest (to the nearest dollar) would be saved on the following loan if the home were…

A: Here, Original financing years = 30 years To Find: Interest savings =?

Q: Which of the following statements is true? Select one: a. The nominal interest rate is always…

A: The interest rate preceding inflation is referred to as the nominal interest rate. Nominal could…

Q: and/or the Banker date of maturity. The effective date is the date the loan was writ Consumer…

A: Banker's rule consider 360 days in year but while calculating the interest the actual number of days…

Q: what is an annuity? Provide an example

A: Annuity is an important concept in finance especially in the context of time value of money. Annuity…

Q: to trade at par? A company releases a five-year bond with a face value of $1000 and coupons paid…

A: Face value or maturity value = Q = $1,000 Semiannual YTM = YTM = 0.03 (i.e. 0.06 / 2) Semiannual…

Q: Suppose you receive $10,000 and have an opportunity to earn a real rate of return of 10% (assume…

A: Perpetuity will be reflective of a stream of cash flows which will be provided forever. The present…

Q: he market price of TRUST bond is currently $890. Its par value is equa nd it is expected to mature…

A: Price of bond is the present value of coupon payment and present value of par value bond taken on…