Create tables showing the four loan repayment methods

Assignment Help Finance Basics
Reference no: EM131977145

Question: An owner of a small business borrows $785,000 at 6.9% annual compound interest. The loan is to be repaid over a 7-year period using the four possible repayment methods. Payments are made at the end of the year. Solve using Excel. Use Excel Functions/Operations to create 4 tables showing the four loan repayment methods.

Reference no: EM131977145

Questions Cloud

Determine amount of dividend to be distributed to each class : Determine the amount of dividends to be distributed to each class of stock for each of Solar Storm's dividend payments.
What is the account effective annual rate of return : If a four-year interest bearing account yields an 8 percent nominal annual rate of return that is compounded quarterly, what is the account's effective annual.
Find the refractive index of the liquid : A thin slit illuminated by light of frequency f produces its first dark band at ±41.0° in air. When the entire apparatus (slit, screen, and space in between)
How much cash will you have from the sale once you pay : You have just sold your house $900,000 in cash. Your mortgage was originally a 30-year. How much cash will you have from the sale once you pay off the mortgage?
Create tables showing the four loan repayment methods : An owner of a small business borrows $785,000 at 6.9% annual compound interest. The loan is to be repaid over a 7-year period using the four possible repayment.
Sixth order for a transmission grating : What is the longest wavelength that can be observed in the sixth order for a transmission grating having 4650 slits/cm?
Calculate the speed of the water : The flow rate through the hose and nozzle is 0.679 L/s. Calculate the speed of the water (m/s) in the nozzle.
How does each part contribute to the financial plan : The four main parts of a financial plan include setup cost, cash-flow statement, record-keeping systems, and assets and liabilities statement.
How many years from the present would the final payment made : Four years ago $100,000 was borrowed at 14% per year compounded annually, to be repaid in equal annual payments over 20 years.

Reviews

Write a Review

Finance Basics Questions & Answers

  Business continuity planning is really an it issue

"Contracting for a standby hot site is too cost-prohibitive except in the rarest of circumstances. Therefore, the vast majority of companies should think in terms of providing for a cold site at most." Do you agree? Why or why not?

  City recognize in grant revenue in government wide statement

Suppose the same facts as in the previous example. Determine how much should the city recognize in grant revenue in its government-wide statements.

  Difference between common stock and preferred stock?

What is the difference between common stock and preferred stock?

  What is the value of a share of gillette stock

Assume Gillette Corporation will pay an annual dividend of $0.64 one year from now. Analysts expect this dividend to grow at 12.6% per year thereafter.

  Evaluating investment projects in given problem

Why are incremental cash flows rather than contributions to reported earnings the appropriate basis for evaluating investment projects?

  Determine the fair value of beta ltd stock

Dividends are expected to grow at 4% p.a. for each of the next five years and then to remain constant forever. Assume a required rate of return of 7% p.a., and that dividends are paid at the end of each year. Determine the fair value of Beta Ltd s..

  Use print and online sources to collect information

Use print and online sources to collect information on your firm's recent acquisitions.

  Describe the effect on the economy during election years

In the past, some people believed that the Federal Reserve routinely expanded the money supply during presidential election years in order to stimulate.

  Which contractor should sharon use

Sharons best available use of the money to do the strip and repair job is 8 percent. Which contractor should sharon's use?

  Graduation from law school

On Abby Ellen's graduation from law school, Abby's uncle, Bull Brady, promised her a gift of $24,000 or $2,400 every quarter for the next 4 years after graduating from law school.

  Calculate the n, r, mo and me

Toyco needs to raise $5 million in a rights offering. If the subscription price is $10 per share, the stock price is $12.50 per share, and there are 4 million shares outstanding, calculate the N, R, Mo and Me.

  Which is the annual depreciation amounts for a vehicle

Using units of productions, which is the annual depreciation amounts for a vehicle which cost $42,000, has a salvage value of $4,000, a useful life of 4 years ad 100,000 miles, driven 22,000 miles this year?

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