Please include the excel formula What are the portfolio weights for a portfolio that has 145 shares of Stock A that sell for $47 per share and 200 shares of Stock B that sell for $21 per share? Input area:               Shares of A  145      Share price of A $47      Shares of B  200      Share price of B $21              (Use cells A6 to B9 from the given information to complete this question.)               Output area:               Portfolio value       Weight of A        Weight of B

Q: Afamily has a $110,662, 15-year mortgage at 6% compounded monthly (A) Find the monthly payment and…

A: A mortgage is a type of covered loan provided for the purchase or maintenance of the real estate.…

Q: RFC Corp. has announced a$2.40 dividend. If​ RFC's last price​ cum-dividend is $48 ​, what should be…

A: Cum-dividend price = $48 Dividend = $2.40 Ex-dividend price = ?

Q: Calculate the price of a $1,000, 5% bond with three years to maturity with 7.5% market interest…

A: The Price of Bond is calculated with the help of following formula  Price of Bond = Present Value of…

Q: You find a zero coupon bond with a par value of $10,000 and 20 years to maturity. The yield to…

A: Given,  The par value is $10000 Yield to maturity is 4.2% Term to maturity is 20 years

Q: What is cost of financial distress to the firm without going bankrupt?Give two examples.

A: The financial distress costs are all such cost incurred by company due to the probability that it…

Q: Calculate the effective duration of an option-free 20-year 7% annual-pay par bond based on a…

A: Effective duration of a bond Effective duration measures the percentage change in bond price when…

Q: Regarding question 4. can you calculate the Bond value for pleasant Innovation? the question never…

A: Pleasant Innovation: Data given: Face Value=$100 Issue Price=$100*98% = $98 Coupon rate=3% (paid…

Q: e will require a return of at least 9% on her stock investments and 4% on bond investments.…

A: The dividend growth model can be applied to calculate the price of stock based on constant growth of…

Q: The most liquid asset is:*   A. A car B. A computer C. A house D. Money in a checking account E.…

A: An asset that is easily convertible into cash and can be done so quickly is referred to as being…

Q: a) How much will you have in the account in 35 years? LA b) How much total money will you put into…

A: Information Provided: Weekly deposit = $470 Interest rate = 2.3% compounded weekly Period = 35…

Q: Using the relation R= find the amortization schedule for a loan of GH¢4000 (1-(1+i)-", to be paid…

A: Data given: P=Loan amount =GHc 4000 N=2 years n=Period = 2 years * 4 = 8 Interest=7.5% (compounded…

Q: What should be the prices of the following preferred stocks if comparable securities yield 6…

A: Information Provided: Yield = 6% A: MN Dividend = $11 & Par value = $190 B: CH Dividend = $11…

Q: Consider the following information: State   Probability   Stock A   Stock B   Stock C  Boom…

A:

Q: In 8 years, Lang Company will have to repay a $90,000 loan. Assume a 4% interest rate compounded…

A: Loan to repay "FV" = $90,000 Number of years to repay = 8 Number of periods to repay "n"= 8*4 = 32…

Q: Proctor and Gamble's total amount of debt increased from 31.9% in March 2011 to 34.2% in December…

A: Bond Issues: A company issues bonds for various purposes.  The tenure of the bond, its face value,…

Q: The article highlights an important relationship between the corporate bond yields and the U.S.…

A: Points for consideration: i) Bond's coupon rate is fixed ii) Price of bond fluctuate in secondary…

Q: Which one of the following factors may affect stock return but out of the CEO's control?This chould…

A: Several factors have been given that are expected to impact the stock's price. We have to find the…

Q: Please include the excel formula Suppose you bought a bond with an annual coupon of 6 percent one…

A: A Bond refers to a concept that is defined as an instrument that represents the loan being made by…

Q: Determine how much is in each account on the basis of the indicated compounding after the specified…

A: Given, P is $5000 r is 3.1%

Q: Your client, Tom, has come to you inquiring about retirement. He wants to know approximately how…

A: Given: Annual retirement amount “PMT” = $182365 Number of years post retirement = 90-64 = 26 Nominal…

Q: You are earning an average of $46,500 and will retire in 10 years. If you put 20% of your gross…

A: Average earning = $46,500 Annual deposit (P) = 46500*0.20 = $9300 Interest rate (r) = 7% Period (n)…

Q: You have an HO policy with the following limits: A $75,000 (dwelling) B-S 7,500 (other structures)…

A: Characteristics of an HO policy have been provided. We have to find the amount insured will claim…

Q: Amou it Financed Calculate the Monthly principal and Interest (Round dallars to necrest Cent)…

A: Given, Loan amount is 240,000 Interest rate is 7.50%

Q: You deposit $200 each month into an account earning 6% interest compounded monthly. a) How much will…

A: Monthly deposit (C) = $200 Monthly interest rate (r) = 0.005 Monthly period (n) = 180 (i.e. 15 years…

Q: Consider a synthetic forward option, with the strike price, K = $19, while the initial stock price =…

A: The synthetic forward contract is used to create an artificial forward position by buying/selling a…

Q: Discuss about that how monetary policy is helpful for Economy.

A: Monetary policy plays an important role in the development of an economy. By pursuing expansionary…

Q: List the pros and cons of functional versus divisional structures( minimum of 4 examples)

A: Functional structure means the grouping of jobs of similar nature or employees having a similar area…

Q: f the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c)…

A: Loans are paid by the equal monthly installments that carry the payment for interest and payment for…

Q: 2. Conspicuous Consumption Ine, a prominent consumer products firm is debating Whether or not to…

A: Given: Particulars All equity Equity and debt Shares outstanding 8000   Share price 70…

Q: Alpine Luggage has a capacity to produce 420,000 suitcases per year. The company is currently…

A: The fixed costs are those cost that has no relation to the level of activity and remains the same at…

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

A: Here, Gifted sum = $50,000 Tax rate = 25% To Find: Expected intrinsic price of each stock in year…

Q: It is usually possible to reduce the risk of investing in the stock market by buying a wide range of…

A: Investment in the stock market is very risk so proper planning and strategies are required to reduce…

Q: Given the following historical returns, calculate the average return and the standard deviation:

A: Information Provided: Year 1 Return = 14%  Year 2 Return = 10% Year 3 Return = 15% Year 4 Return =…

Q: A company just paid a dividend of $4.15 per share. The company is expected to increase its dividend…

A: Dividend model have been used to calculate the price of stock based on the two stage growth model…

Q: Find the future value of the following ordinary simple annuity Payment Interval 1 month Periodic…

A: Annuity is a series of equal receipts/payments made at a regular interval of time (monthly,…

Q: How many units of each stock will Stephanie buy? Support your response with relevant computations.

A: Given: Particulars Pan Elixir Rebound Cheers Think local Last year dividend $2.50 $0.50 $1.00…

Q: Question 7 Mike has retired and has invested in the following annuity scheme: Investment: $250,000…

A: We need to rearrange the PV of annuity formula to determine the interest rate. The PV of ordinary…

Q: A stock that currently sells for $150 has a required return of 11.45% and dividend yield of 3%. What…

A: Select financials about a stock are available. We have to find the expected dividend from the stock.

Q: BK Inc. has $100,000 that can be used for arbitrage in the forex market. The interest ra is US is 4%…

A: Arbitrage Profit - It is the concept which is used to generate income in two or more different…

Q: Ferrari Corp., an automotive producer with a current debt-to-equity ratio of 3, is considering…

A: We need to find the unlevered cost of equity of the bicycle industry, first and then lever it to…

Q: Please discuss the Foreign Currency -Major Minor Exotic Their definitions, similarities and…

A: Foreign currency It is the recognized form of monetary exchange used by the foreign country and is…

Q: low much money should be deposited today in an account that earns 5% compounded semiannually so that…

A: Interest rate is 5% Compounded semi -annually Future Value or A is $13,000 Time period is 3 years…

Q: Answer True, False or Uncertain. Briefly explain your answer. 4. The rate of return equality is…

A: Equity Premium Puzzle-We all are aware that higher the risk involved, greater will be the return.…

Q: What is the present value of $8,500 per year at a discount rate of 6.7 percent if the first payment…

A: Information Provided: Interest rate = 6.7% First payment period = Year 6 Last payment period = Year…

Q: Fujita, Incorporated, has no debt outstanding and a total market value of $222,000. Earnings before…

A: Return on equity (ROE) It is calculated as shown below. ROE=Net earningsTotal equity

Q: What is the future value in 11  years of $1,000 invested in an account with an APR of 8.9 percent:…

A:

Q: An 8% semiannual coupon bond matures in 4 years. The bond has a face value of $1,000 and a current…

A: The proportion of the bond price that is realized as the coupon payment in one year is called the…

Q: promised to pay his son $300 semiannually for 9 years. Assume Pete can invest his money at 8% in an…

A: There is need of proper planning for the future and if done on the proper time it can have proper…

Q: From California to New York, legislative bodies across the United States are considering eliminating…

A: Non customers earn wage - $ 26/ hr ATM fees - $ 3.50 / transaction   Based on the given information,…

Q: Suppose risk-free rate of return = 2%, market return = 7%, and Stock B’s return = 11%. Calcuate…

A: The Expected return is calculated by using Capital Asset Pricing Model. It is calculated with the…