Use to create project amortization schedule

Assignment Help Financial Management
Reference no: EM13919802

The goal of this project is to create a worksheet that through inputs and a series of formulas is 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: EM13919802

Questions Cloud

Share one internet access connection : The whole building will share one Internet access connection (T-1 link from Verizon). This connection will come into the Server Room on the first floor.
Explain why the amount of interest earned increases : You have $1,500 to invest today at 7% interest compounded annually. Find out how much will you have accumulated in the account at the end of number of. Compare and contrast your findings in part b. Explain why the amount of interest earned increases ..
Borrower to pay two points to lender up front-repay loan : You are looking at a one-year loan of $15,000. The interest rate is quoted as 10.0 percent plus two points. A point on a loan is simply 1 percent (one percentage point) of the loan amount. Quotes similar to this one are common with home mortgages. Th..
Discuss the difference between fairness and justice : Discuss the difference between "fairness" and "justice"? Should stakeholders be treated "fairly" or "justly"? Discuss.
Use to create project amortization schedule : The goal of this project is to create a worksheet that through inputs and a series of formulas is 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 usi..
Network security structure : After looking at your network security structure there are various physical threats that we will focus on that could have a Hugh impact on your business intellectual property and availability.
Medium-sized business in information security department : Imagine you work for a medium-sized business in the information security department and suppose you've determined the need to structure and implement an incident response plan and team. Propose how you would make a business case for the management..
The following information was drawn from the annual report : The following information was drawn from the annual report of Active Wilderness Adventures (AWA).
Describe the typical fuel assembly configurations : What are the key advantages and disadvantages of using a liquid metal as a coolant in a nuclear reactor? Briefly explain and describe and draw diagrams for the two typical configurations that can be used for a liquid metal cooled reactor.

Reviews

Write a Review

 

Financial Management Questions & Answers

  There are two questions on financial planningq why do you

there are two questions on financial planning.q why do you think most long term financial planning begins with the

  Consider an option on a non-dividend-paying

Consider an option on a non-dividend-paying stock when the stock price is $107, the exercise price is $102, the risk-free interest rate is 5% per annum, the volatility is 25% per annum, and the time to maturity is four months.

  What is the cost of common equity

Summerdahl Resorts' common stock is currently trading at $30.00 per share. The stock is expected to pay a dividend of $1.75 a share at the end of the year (D1 = $1.75), and the dividend is expected to grow at a constant rate of 5% a year. What is the..

  What is the firms cost of equity

Chelsea Fashions is expected to pay an annual dividend of $0.80 a share next year. The market price of the stock is $22.40 and the growth rate is 5 percent. What is the firm's cost of equity?

  Own business and is considering an investment

Marian Plunket owns her own business and is considering an investment. If she undertakes the investment, it will pay $4000 at the end of each of the next three years. The opportunity requires an initial investment of $1000 plus an additional investme..

  Work patterns in the housekeeping department

Management has studied work patterns in the housekeeping department and estimates the number of hours to be worked as follows. Hours worked = (1,500 hours per month) + (0.50 × RVUs). For the coming month, management expects RVUs to be 5,800. What sho..

  Government and corporate bond fund-T-bill money market fund

A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a sure rate of 4.4%. What is the standard devia..

  Annual fuel costs required to operate solid-waste treatment

The annual fuel costs required to operate a small solid-waste treatment plant are projected to be $1.5 million, without considering any future inflation. The best estimates indicate that the annual inflation-free interest rate (i') will be 6% and the..

  Expansion of the commercial paper market

What factors contribute to an expansion of the commercial paper market and what factors cause a contraction in the commercial paper market?

  How much can you withdraw each year in your retirement

You are planning your retirement in 10 years. You currently have $160,000 in a bond account and $600,000 in a stock account. You plan to add $8,000 per year at the end of each of the next 10 years to your bond account. How much can you withdraw each ..

  Entire amount of the transaction deposits

As of today, the First ECON Bank of Arlington currently holds: If we assume that that entire amount of the transaction deposits is a subject to the legal 10% reserve requirement, please indicate the required course of the bank’s action to manage its ..

  What annual rate of return is she expecting

An individual has $1,100,000 in a retirement account. at the beginning of each mint she plans to withdraw $10,000 for the next 30 years depleting the account, what annual rate of return is she expecting? if she is only able to earn 8% a year on her m..

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