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.

User Account

All Pages