Using the table below please compute for (a) and (b) Given the data here, Ea. Compute the average return for each of the assets from 1929 to 1940 (the Great Depression).b. Compute the variance and standard deviation for each of the assets from 1929 to 1940.c. Which asset was riskiest during the Great Depression? How does that fit with your intuition?Note: Notice that the answers for average return, variance and standard deviation must be entered in decimal format. ABDEF1 Yearly returns from 1929-1940 for the S&P 500, small stocks, corporate bonds, world portfolio, Treasury bills, and inflation (as measured by the CPI).2 YearS&P 500 Small Stocks Corp Bonds World Portfolio Treasury Bills-0.08907-0.25257CPI31929-0.504670.04321-0.076920.047370.0074641930-0.455830.06343-0.225740.02347-0.0642-0.502160.08696-0.393050.03031931-0.43858-0.02380.01023-0.092356.1932-0.088610.528950.121980.00806-0.1046570.009740.0128619331.8720.052550.664490.002931934-0.023410.252090.097280.025520.00155919350.472080.647390.06860.227820.001650.031751019360.328010.875080.012310.03040.06220.192830.001751937193811-0.35258-0.534030.02546-0.16950.00319120.331990.262750.043570.056140.00041-0.0295130.00184-0.12341939-0.00910.04247-0.014410.00008141940-0.100820.045120.03528-0.000580.0091215

Use excel as follows to calculate average return , variance and standard deviation

Given the data here, a. Compute the average return for each of the assets from 1929 to 1940 (the Great Depression). b. Compute the variance and standard deviation for each of the assets from 1929 to 1940. c. Which asset was riskiest during the Great Depression? How does that fit with your intuition? Note: Notice that the answers for average return, variance and standard deviation must be entered in decimal format.

Given the data here, a. Compute the average return for each of the assets from 1929 to 1940 (the Great Depression). b. Compute the variance and standard deviation for each of the assets from 1929 to 1940. c. Which asset was riskiest during the Great Depression? How does that fit with your intuition? Note: Notice that the answers for average return, variance and standard deviation must be entered in decimal format.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 38P: Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly...

See similar textbooks

Similar questions

Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly payments should equal 556.11. The key relationships are that for any month t (Ending month t balance) = (Ending month t 1 balance) ((Monthly payment) (Month t interest)) (Month t interest) = (Beginning month t balance) (Monthly interest rate) Of course, the ending month 60 balance must equal 0.
On-Balance Sheet Items (Assets) (in millions) Cash $ 10,000 Government securities 30,000 Interbank deposits 5,000 Home loans to personal finance customers 20,000 Loans to corporate customers 75,000 Total Balance Sheet Assets $140,000 Off-Balance Sheet Items Standby letters of credit backing corporate borrowings $ 10,000 Long term unused loan commitments made to private corporations 20,000 Total Off-Balance Sheet Items $30,000 Bank Capital Common stock (par value) $ 1,000 Surplus 1,500 Retained earnings 1,500 Subordinated debentures 2,000 Minority interest in subsidiaries 1,000 Allowance for loan and lease losses (reserves) 1,000 Non cumulative perpetual preferred stock 1,000 Intermediate term preferred stock 4,000 Equity commitment notes 2,000 Basel…
- Consider demand: x(p₁) = 400 — 2p1 At a market price of p₁ = $125 per unit: • Determine the social loss due to moral hazard when assuming: 1. Full insurance compared to uninsured 2. A co-payment of $50 compared to uninsured 3. A 75% coinsurance rate compared to uninsured
H1. Account Where a company has no history with declaring and paying dividends, it will need to use an alternate method to value its stock. What are some of the key concerns in using the PE ratio to value stock?
Suppose a certain manufacturer deposits $7,000 at the beginning of each 3 month period for 6 years in an account paying 8% interest compounded quarterly. (Round your answers to the nearest cent.) (a) How much (in $) will be in the account at the end of the 6 year period? $ (b) What is the total amount (in $) of interest earned in this account? $
Construct the cost living index number by (i) Aggregative expenditure method. (ii) Family budget method for the year 2004 taking 200 as base. Commodity Quantity Unit price($) 2000 2004 |2 Qnts Qnt 25 kg Qnt 10 kg kg kg 25kg Clothing 25 met Meter 4 Qnts Qntl |House woeat 50 75 Rice 100 120 Sugar Pure Ghee5 kg Veg. Ghee 5kg Qnt 80 120 10 10 Oil Qnt 200 200 4 Fuel 8 10 Rent |One 20 25
Evaluate the following statements:S1. Any investment income of general borrowing is deducted from capitalizable borrowing cost.S2. If the asset is financed by specific borrowing but a portion is used for working capital purposes, the borrowing shall be treated as general borrowing in determining capitalizable borrowing cost. a.False, False b.False, True c.True, True d.True, False
What-If Analysis As the management accountant for the Tyson Company you have been askedto construct a financial planning model for collection of accounts receivable and then to performa what-if analysis in terms of the assumption regarding estimated uncollectible accounts. You areprovided with the following information:Collection Pattern for Credit Sales: 65% of the company’s credit sales are collected in the monthof sale, 30% in the month following the month of sale, and 5% are uncollectible.Credit Sales: January 2019, $100,000; February 2019, $120,000; March 2019, $110,000.Required1. Generate a spreadsheet model regarding estimated bad debts expense under the following assumptionsregarding the rate of uncollectible accounts: 1%, 3%, 5% (base case), and 8%. Prepare an estimate of baddebts expense for each of three months, January through March, and for the quarter as a whole.2. What is the value to Tyson Company of creating a model and then performing the what-if analysis?
One very important responsibility of the finance department in both large and small businesses involves acquiring needed funds to operate the business. True or False True False 27 atv S A P 28
3:25 ull 1 Search A moodle1.du.edu.om Topic: Ch 3 ): Assume you are the finance manager of Methanol Company, and the company is considering investing in one of the two projects. The life for both the Projects X and Project Y is 6 years. Project X costs OMR. 20500 and Project Y costs OMR.20500. The discount rate/cost of capital is 3.55%. Required: Use the following techniques to help company to decide which Machine is better and justify why? a) Payback period b) Discount payback period c) Net Present Value d) Present value index -Profitability index. Year Project X Project 1 9876 9300 2 7056 7609 3 9676 4508 7050 8905 9900 9904 3490 1239 : What factors should you keep in our mind as a financial manager when selecting methods of capital budgeting? and Why is rebalancing between methods of capital budgeting are important? II
A restaurant borrows $15,200 from a local bank for 10 months. The local bank charges simple interest at an annual rate of 4.55% for this loan. Assume each month is 112 of a year. Answer each part below.Do not round any intermediate computations, and round your final answers to the nearest cent. If necessary, refer to the list of financial formulas . (a) Find the interest that will be owed after 10 months. $ (b) Assuming the restaurant doesn't make any payments, find the amount owed after 10 months.
7:17 PM O A D Å ןה.ןא 288 I31) B/s Reserve Board interest-rate increases. Create a spreadsheet to compare the difference in monthly payments for a K552,451 loan having 60 monthly payments for a select number of interest rates. Use 3% as the base APR and go as high as an APR of 12%. Required: Make your spreadsheet flexible enough to be able to look at the impact of the different interest rates for different loan amounts and different repayment periods. Question Two (Evaluating Projects/probabilistic analysis) Malama's Cafe, Inc., is considering investment in two alternative capital budgeting projects. Project A is an investment of ZMK75000 to replace working but obsolete refrigeration equipment. Project B is an investment of ZMK 150000 to expand dining room facilities. Relevant cash flow data for the two projects over their expected 2-year lives are as follows: PROJECT A YEAR ONE YEAR TWO Probability Cash Flow Probability Cash Flow 0.18 ZMK O 0.08 ZMK O ZMK 50,000 ZMK 100, 000 0.64 0.84…