Develop an e?ective interest rate calculator.

Assignment Help Financial Econometrics
Reference no: EM131198000

Question 1

a. Use Goal seek to solve the question in a spreadsheet. Make sure you carefully document the steps you used in the spreadsheet.

b. Use Solver to solve the question in a spreadsheet. Make sure you carefully document the steps you used in the spreadsheet.

Next, develop an e?ective interest rate calculator.

c. The calculator you develop should satisfy the following speci?cations.

  • In the top cell the user enters the percentage nominal rate (like 7%).
  • In the next cell the user enters the annual frequency of the nominal rate, i.e., the n from jn.
  • In the next cell the spreadsheet calculates the effective daily rate of interest. (Assume 365 days in a year.)
  • In the next cell the spreadsheet calculates the effective weekly rate of interest. (Assume 52 weeks in a year.)
  • In the next cell the spreadsheet calculates the effective monthly rate of interest.
  • In the next cell the spreadsheet calculates the effective quarterly rate of interest.
  • In the next cell the spreadsheet calculates the effective half yearly rate of interest.
  • In the next cell the spreadsheet calculates the effective annual rate of interest.

Graph your results, displaying the log interest rate1 on the vertical axis and the nominal, then effective rates, on the horizontal axis (in the order given above).

Present your answers to the above questions in a spreadsheet, giving each solution on a separate sheet (labelled 'Part a', 'Part b', and 'Part c'). Your spreadsheet should be clearly labelled and easy to understand. Make sure you identify what the "inputs" and "outputs" are.

Reference no: EM131198000

Questions Cloud

Government interventions in the economy : Create an argument for or against the passage of such a law based on your conception of the ideas on the optimum size of government and on government interventions in the economy (Social Security is an intervention in the economy).
The various ways inflation can hinder economic activity : Discuss the various ways inflation can hinder economic activity. What are some strategies you might use in your life to deal with rising inflation? How might these strategies change if we experienced deflation?
Discuss the physical changes in boys and girls : Discuss the physical changes in boys and girls. Discuss how puberty affects emotional and social development in boys and girls.
Contributed to labor market rigidity in latin america : 1. What are some of the factors that have contributed to labor market rigidity in Latin America? Provide three explanations.
Develop an e?ective interest rate calculator. : ACST201 Financial Modelling. Next, develop an e?ective interest rate calculator. The calculator you develop should satisfy the following speci?cations.In the top cell the user enters the percentage nominal rate (like 7%)
Price measured in a common currency : If the price measured in a common currency) of a particular basket of goods is 13 percent higher in the U.S than it is in the United Kingdom, which country country's currency is overvalued, according to the theory of purchasing power parity? Explain.
Difference between monetary policy and fiscal policy : What is the difference between monetary policy and fiscal policy?
Think of an example of the principal-agent : Think of an example of the principal-agent that you experienced first-hand or read or heard about. What factors led to the problem? Were there serious adverse outcomes arising from the problem? Based on the course material, what suggestions can you o..
Identify the business problems of each of the given cases : Identify the business problems of each of the cases; describe the metaphor(s) used. Rank-order the critical issues stated in the cases Evaluate the proposed solutions. Are the solutions valid? Why or why not?

Reviews

Write a Review

 

Financial Econometrics Questions & Answers

  Prepare a capital budget for the items to be acquired

The expected lifetime of the various capital items is 10 years for the garbage trucks, 8 years for the bulldozer, 5 years for the lawn mowers, and 40 years for the activity center.

  Objectives and principles guiding corporate governance

What is corporate governance and what are the objectives and principles guiding corporate governance?

  Determine what would the account be worth in 35 years

If you deposit $3,500 today into an accoun earning an 11 percent annual rate of return, what would your account be worth in 35 years (assuming no further deposits). In 40 years.

  What is the firms gain or loss at sales of 10000 watches

The Weaver Watch Company sells watches for $23, the fixed costs are $100,000, and variable costs are $10 per watch. What is the firm's gain or loss at sales of 10,000 watches

  What is the value of the plant at the end of year 1

The manufacture of folic acid is a competitive business. A new plant costs $100,000 and lasts for three years. The cash flow from the plant is as follows: year 1: +$43,300, year 2: +$43,300 and year 3 = +$58,300

  Find what will be telecommunications dividend payout ratio

Axel Telecommunications has a target capital structure that consists of 60% debt and 40% equity. The company anticipates that its capital budget for the upcoming year will be $3,000,000.

  How much would be willing to lend the business owner

A small business owner visits his bank to ask for a loan. The owner states that she can repay a loan at $1,250 per month for the next 3 years and then $500 per month for two years after that.

  Determine what is the price of these three bonds in dollars

a Treasury note quoted at 98:25, a corporate bond quoted at 103.20, and a municipal bond quoted at 101.85. If the Treasury and corporate bonds have a par value of $1,000

  Calculate the expected return on package of stock and bond

Assume that the bonds are default-free and that there are no taxes. Now assume that Hubbard's issues more debt and uses the proceeds to retire equity. The new financing mix is 35% equity and 65% debt.

  Calculate the operating cash flows of the project

The factory originally cost $1.25 million and is being depreciated for tax purposes over 25 years using straight-line depreciation. Calculate the operating cash flows of the project if the firm's tax bracket is 40%.

  Determine the rr would equal to what value

If M = the quantity of money, m the money multiplier, MB the Monetary Base, C = Currency, D = Deposits, R = Reserves, RR equals required reserves, rD = the required reserve rate and ER = Excess reserves

  How much does a share of preferred stock cost today

The issue will pay a $19 annual dividend in perpetuity, beginning 11 years from now. If the market requires a 12 percent return on this investment, how much does a share of preferred stock cost today

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