Use to create project an amortization schedule

Assignment Help Financial Management
Reference no: EM13921447

The goal of this project is to create a worksheet that through inputs and a series of formulas, be a basis of an expandable tool, that you can use to create project an amortization schedule.

The spreadsheet should be able to do various calculations using automated formulas.

Both, fully amortizing, partially amortizing (balloon) or Interest only (bullet).

there should be no balance or payment of interest past the term

Yield with or with out closing costs.

Interest Only periods.

should be fully formula driven

Able to change loan amount, amortization period, term length, interest rate.

Go crazy and include these calculations for 5%% extra credit for each item do one do them all.

calculate date of each payment

calculate interest and principal for calendar or loan year

Actual vs 360 payments.

Average life

Duration

Reference no: EM13921447

Questions Cloud

Assignment on political parties and the electoral process : Write a three to four (3-4) page paper on the relationship between political parties and the electoral process in which you:
Project- zappos : Project- Zappos. Conduct academic research and prepare a 2-3 page introductory report in APA format on management style and motivation methods leading to employee satisfaction and outstanding customer service at Zappos
Do you see any potential problems with the new plan : Do you see any potential problems with the new plan? Explain. substantially altered the environments of some of these companies.
Objectives, functional tactics, and action items : Although objectives, functional tactics, and action items are included in many implementation plans, why do some organizations have a difficult time reflecting the plan they create?
Use to create project an amortization schedule : The goal of this project is to create a worksheet that through inputs and a series of formulas, be a basis of an expandable tool, that you can use to create project an amortization schedule.
Probability that selected student is caucasian or black : What is the probability that a randomly selected student is either Caucasian or Black?
Discount interest-what is the interest rate on this loan : This question illustrates what is known as discount interest. Imagine you are discussing a loan with a somewhat unscrupulous lender. You want to borrow $20,000 for one year. The interest rate is 17.25 percent. What is the interest rate on this loan?
Assignment on conducting an environmental analysis : For all assignments assume that you are the administrator of a fictitious organization of your choice. The organization can be any type of health care organization such as a hospital, nursing home, rehabilitation center, clinic, etc.
The strategic plan for your organization : Risk management plan, including contingency plans for identified risks, Format your plan consistent with APA guidelines.

Reviews

Write a Review

Financial Management Questions & Answers

  What is the dividend yield

For the past six years, the price of Slippery Rock stock has been increasing at a rate of 9.6 percent a year. Currently, the stock is priced at $67 a share and has a required return of 14 percent. What is the dividend yield?

  Two different bonds currently outstanding

The Morgan Corporation has two different bonds currently outstanding. Bond M has a face value of $30,000 and matures in 20 years. The bond makes no payments for the first six years, then pays $2,400 every six months over the subsequent eight years, a..

  Borrowers in fixed mortgage rate and variable mortgage rate

What are the differences to the borrowers between Fixed Mortgage Rate and Variable Mortgage Rate? If the cost of capital is low and there is little demand for the product, would companies still expand their capital investment?

  How does an ipo differ from a seasoned equity offering

How does an IPO differ from a Seasoned Equity Offering? When the underwriters are acting under a firm commitment, what services do they provide for the private company attempting their IPO? How are the underwriters compensated for such services?

  International trade agreements eliminate trade barriers

international trade agreements eliminate trade barriers between countries promote investments infuse competitiveness

  The two most basic components of any investment opportunity

The two most basic components of any investment opportunity are risk and return. Define each and explain how they are related in the investment world. Why does their relationship matter to you as an investor?

  What does camels stand for

Regulators use the CAMELS system to analyze bank risk. What does CAMELS stand for and what financial ratios might best capture each factor?

  Analysis indicate to the firms managers

Technology Corp. is considering a $260,000 investment in a new marketing campaign which they anticipate will provide annual cash flows of $54,000 for the next 6 years. The firm has a 10% cost of capital. What should the analysis indicate to the firm'..

  What will be growth in demand for owner-occupied units

Suppose that the annual growth in real income in Japan is expected to be between 2 and 3 percent and that income elasticity of demand for housing in Tokyo is estimated to be between 0.8 and 1.0 for rental units and between 0.7 and 1.5 for owner-occup..

  Find your amount due at the closing

You are interested in purchasing a home listed at $120,000. The down payment is 30% and the balance will be financed with a 20-year mortgage at 9% and 3 discount points. You put down a deposit (applied to the down payment) of $15,000 when you signed ..

  Re-invest the coupons at an annual rate

let's say you buy a 12% coupon (paid semi-annually), AA-rated, $1000 par value coupon bond for $1100 when it has 16 years left until it's maturity. You re-invest the coupons at an annual rate of 6% and sell the bond off after 6 years, when its yield ..

  Investor currently hold-what is portfolios expected return

An investor currently holds the following portfolio of 4 stocks, each having equal weight: What is the portfolio’s expected return? What is the portfolio’s beta risk? Is it more or less risky than the market?

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