Please solve using excel. If 200,000 is available for investment and 60,000 is invested at 20%...

Please solve using excel.

If 200,000 is available for investment and 60,000 is invested at 20% per year with the remainder is invested at 12% per year. What is the overall rate of return on the 200,000?

Expert Solution

Rahul Sunny answered 1 year ago

An Investor has $200,000 invested in a 2-stock portfolio. $60,000 is invested in Stock X and...

An Investor has $200,000 invested in a 2-stock portfolio. $60,000 is invested in Stock X and the remainder is invested in Stock Y. X's beta is 1.2 and Y’s beta is 1.5. What is the portfolio's beta?

*SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED**** A company is considering...

*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000. In addition, the machine must be installed and tested. The costs of installation and testing will amount to $10,000. The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it) The equipment will...

PLEASE SOLVE LP IN EXCEL The Strategic Investment Corporation is developing a mix of investments to...

****PLEASE SOLVE LP IN EXCEL**** The Strategic Investment Corporation is developing a mix of investments to meet the needs of a client with one million dollars to invest. A mix of five investments is being considered, with data on each as shown below: Average Maximum Minimum Investment Annual Return Investment Investment A 10% 500,000 none B 12% 275,000 none C 16% 250,000 5,000 D 14% 125,000 10,000 E 9% none 5,000 The total average return must be at least 12.5%,...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$ 26,500 Units started during April ......................................................................................................................................100,000 Units...

Solve the following questions in excel using the skills from class. Lindner is considering an investment...

Solve the following questions in excel using the skills from class. Lindner is considering an investment with an initial cost of $122,400 and salvage value of 63,600 with the following cash flows over the next 6 years: Year Cash flow 1 $28,750 2 $19,500 3 $44,100 4 $27,900 5 $15,850 6 $13,050 The discount rate is 14.8%. Find the NPV and IRR, what is the decision and what was the criteria for each rule? You want to analyze the impact...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...

How can I solve this in Excel? Please show how to solve it in excel step...

How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...

Using NPV in Excel how do I solve for: An investment offers the following annual cash...

Using NPV in Excel how do I solve for: An investment offers the following annual cash flows: End of years 1 thru 10, $5000, years 11 thru 20, $7500. If your required return on this investment is 6% what is it worth today?

Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter...

Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter grade Nested loop Student ID Grade Letter Grade 1 5 If score is Then return 2 55 Greater than 89 A 3 86 From 80 to 89 B 5 64 From 70 to 79 C 6 25 from 60 to 69 D 7 56 less than 60 F 8 58 9 99 10 90 11 28

Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next...

Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next four months, respectively, 50, 65, 100, and 70 units of a commodity (no backlogging is allowed). Production costs are $5, $8, $4, and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 could be sold for...

Question