Calculate the book value per share for each year

Assignment Help Finance Basics
Reference no: EM131298562

PRINCIPLES OF FINANCIAL ANALYSIS

SPREADSHEET ASSIGNMENT: Future Value, Rate of Return, Present Value

1. Retrieve the file BUFFETTP.XLS.  The book value per share of Berkshire Hathaway Inc. was $19.46 in 1964, as noted in cell A6. Column D reports the annual growth rate in book value for the next 51 years.

2. Calculate the book value per share for each year from 1965 through 2015.  For example, the computed value in cell E6 equals the original value reported in cell A6 plus the calendar year growth rate in book value appearing in cell D6.  The value in cell E7 is equal to the computed value in cell E6 plus the annual growth rate in cell D7.  Use the copy command to compute values for cells E7:E56.

3. Apply the =RATE financial function command in cell F58 to compute the average annual growth rate in book value per share from the starting value in cell A6 through the ending value in cell E56.  In applying this command, enter 51 for the total number of years, zero for PMT and TYPE, and enter a GUESS of 15% or higher.

4. In cell F59 compute the total percentage rate of growth in book value per share from 1964 to 2015.  [Hint: This value is very large, reflecting Berkshire Hathaway's remarkable record of owning and investing in companies.]

5. Assume that an investor's proportionate share in Berkshire's book value was $1,000 at yearend 1964.  Apply the =FV financial function command in cell F60 to calculate the book value exactly 51 years later.  Enter the value computed in cell F58 for RATE.  [Hint: The compounded value in cell F58 is very large.]

6. Apply the =PV financial function command in cell F61 to verify that the value in cell E56, discounted for 51 years at the annual rate reported in cell F58, equals the book value per share in 1964.

7. Print the worksheet.

Attachment:- Assignment.rar

Reference no: EM131298562

Questions Cloud

Was the price of almonds expected to rise or fall : Almonds galore! The quantity of almonds harvested in 2008-2009 was expected to increase by 22 percent, while total receipts of growers was expected to increase by 17 percent.
Which reporting makes moss look better : Using only the amounts given, compute net cash provided by operations, both without and with the reclassification of the receivables. Which reporting makes Moss look better - Under what condition would the reclassification of the receivables be et..
Review the given paper and check for grammar : The paper topic is: "Moving together with Immigrants".- Review the given paper and Check for grammar and tham edit and fix the mistakes.
What is the change in total surplus : If the quantity demanded decreases by 100 sandwiches an hour at each price, what is the equilibrium price and what is the change in total surplus?
Calculate the book value per share for each year : PRINCIPLES OF FINANCIAL ANALYSIS. Calculate the book value per share for each year from 1965 through 2015.  For example, the computed value in cell E6 equals the original value reported in cell A6 plus the calendar year growth rate in book value a..
What is the value of the test-statistic : What is the value of the test-statistic? What is the critical value? What is your decision; reject the null or do not reject the null? Explain why you made your decision including the results for your p-value and the critical value.
What is the efficient quantity of sandwiches : Calculate the equilibrium price of a sandwich, the consumer surplus, and the producer surplus. What is the efficient quantity of sandwiches?
Compare management of change in public versus private sector : Compare the management of change in the public sector versus the private sector. W/hich would be your recommendations for a process of change in the public sector of Canadian federal government? And for provincial government?
Calculate the u.s. price elasticity of supply of corn : Record U.S. corn crop, up 24%, is forecast The USDA reported that world corn production will be 9.9 percent greater than last year's, while U.S. corn production will be 24 percent larger. The price of corn is expected to be 46 percent higher than ..

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd