A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term bond fund, and the third is a money market fund that provides a safe return of 4%. The characteristics of the risky funds are as follows: Expected Return Stock fund (S) Bond fund (B) The correlation between the fund returns is 0.09. 17% 14 Required A Standard Deviation You require that your portfolio yield an expected return of 14%, and that it be efficient, that is, on the steepest feasible CAL. Required: a. What is the standard deviation of your portfolio? b. What is the proportion invested in the money market fund and each of the two risky funds? Complete this question by entering your answers in the tabs below. Required B Money market fund Stocks Bonds 35% 18 What is the proportion invested in the money market fund and each of the two risky funds? Note: Round your answers to 2 decimal places. Proportion Invested % % % < Required A Required B >

Q: How to draw a npv profile in excel

A: Net Present Value (NPV) is the technique used to discount the cash flows generated over the period…

Q: Hi - could you please send the CAPM model and explain what it is and when to use it please?  Thank…

A: Capital Asset Pricing Model (CAPM):It defines the relationship of an asset’s expected return with…

Q: Which of the following can be used to link two tables together? Select one: a. Primary Key b.…

A: Foreign key is a column or group of columns in a relational database table that provides a link…

Q: help please answer in text form with proper workings and explanation for each and every part and…

A: Understanding VLOOKUP The VLOOKUP function syntax is:VLOOKUP(lookup_value, table_array,…

Q: Show how to insert formula in excel

A: Perpetuity: It is a stream of cash flow that is presumed to continue for an indefinite period.

Q: Student ID Day 63638034 Monday 23957096 Thursday 28080825 Monday Exam Score 61 70 1. How many…

A: =COUNTIF is used to count the cells satisfying the given criteria in the given range.

Q: Coronado Corporation is projecting a cash balance of $35,400 in its December 31, 2021, balance…

A: Cash budget is the statement which is prepared by the entity to record the estimated cash receipts…

Q: what excel formula feature would you use

A: Information Provided: Price of bond = $1135.90 Years to Maturity = 10 Annual Yield to Maturity = 8%…

Q: Natarajan, Inc. had the following operating segments, with the in Segment Expenses $ 650,000…

A: We must contrast the segment revenues with the sum of the revenues of all other segments in order to…

Q: can you hand write it instead of using excel

A: Here,Risk Free Rate is 3%Standard Deviation of Optimal Risky Portfolio is 20%Expected Return of…

Q: Please correct the aswer

A: The current yield of the bond is referred to as the relationship between the annual coupon amount…

Q: Wildhorse Company uses the allowance method for estimating uncollectible accounts. Prepare journal…

A: The journal entries are prepared to record the transactions on regular basis. The allowance for…

Q: n you handwrite this or type it instead of using excel

A: According to the expectation theory short term interest rate should be in line with long term…

Q: Please show all equations and work as needed. Make the correct answer clear. If possible, please…

A: Calculation of WACC of firm after leverage (effective after-tax):Answer:WACC after leverage is…

Q: can you please type out the equation

A: Solution:- When an equal amount is saved each period at end of period, it is called ordinary…

Q: rmn.3 answer must be in table format or i will give down vote

A: Approach to solving the question:I need more context about this. If you give me more information…

Q: Which "view" gives you the ability to drop and drag fields to create relationships between tables? O…

A: The "view" that typically allows you to drag and drop fields to create relationships between tables…

Q: can you provide me more clear info

A: There are five special journals namely, cash receipt journal, cash disbursement journal, sales…

Q: not use ai please

A: To manually divide  110  by  39.37  using long division, follow these steps: Step 1: SetupDivide…

Q: I cannot use excel. please caculate manually

A: Given: Initial salary is $42,200 Salary rise after first year to $45,400 Inflation average is 3%

Q: Prepare the entry for the issuance under the following assumptions. (List all debit entries before…

A: The journal entries are prepared to record the transactions on regular basis. The cash received in…

Q: could you please provide the solution for b and c without using excel?

A: concept. 1. changes in future price = future price of current month - future price of previous…

Q: Write out the journal entry that is created once an entry is made in Invoice Window.

A: Invoice: It implies to a document of commercial nature that has details related to what reflects on…

Q: Which function in excel did you use

A: The concept of time value of money will be used here. The amount needed today will be the sum of…

Q: Describe the purpose of caash receipts journal.

A: The cash receipts journal is a special section of the general journal specifically used to record…

Q: How to create the t account

A: T account is a representation of the legder that records business transactions. It is in the form of…