Determine the quarterly interest rate and aer

Assignment Help English
Reference no: EM13955965

A shipping company orders a new $30,000,000 vessel and finances it through a (financing) lease. Fixed repayments (principal and interest) of $535,735.26 are made quarterly in advance commencing on the day of delivery and are to be made for the duration of the 25 year lease.

You are required to:

Use an Excel spreadsheet and using the actuarial method set out the interest and principal paid each quarter and determine the quarterly interest rate and the AER assuming that there is no balloon payment at the end of the lease. As a check to your model show the total repayments and the total interest paid and by deduction the total principal repaid. If the (same) repayments are paid quarterly in arrears rather than quarterly in advance determine the new quarterly interest rate and the AER assuming that there is no balloon payment at the end of the lease. Using your model with payments in advance, determine the quarterly interest rate and AER assuming there is an outstanding balloon payment at the end of the lease of $3,000,000 

Reference no: EM13955965

Questions Cloud

What was the speed of the wave : Tsunamis are fast-moving waves generated by underwater earthquakes. In the deep ocean their amplitude is barely noticeable, but upon reaching shore, they can rise up to the astonishing height of a six-story building. One tsunami, generated off the..
Create a file for uploading to the discussion board : At this point, you believe customers are now ready to begin risk analysis and understand the risk differences among various investments.
What average speed of antelope for entire period of motion : An antelope runs 350m at a constant speed of 2.20 m/s, then immediately changes speed to 3.50 m/s and runs for a distance of 400m. What is the average speed of the antelope for the entire period of motion? Assume the motion of the antelope is 1-d..
What are the advantages of evaluating projects : What are the advantages of evaluating projects using the net present value and internal rate of return methods instead of the payback and accounting rate of return methods?
Determine the quarterly interest rate and aer : A shipping company orders a new $30,000,000 vessel and finances it through a (financing) lease. Fixed repayments (principal and interest) of $535,735.26 are made quarterly in advance commencing on the day of delivery and are to be made for the durati..
Find the probability that fran wins the tournament. : Fran and Ron play a series of independent games. Fran's probability of winning any particular game is 0.6 (and Ron's probability of winning is therefore 0.4). Suppose that they play a best-of-5 tournament. (That is, the winner of the tournament is..
How do the two companies stack up in terms : How do the two companies stack up in terms of these ratios? Which company is performing better? Why?
Probability the measure makes a correct diagnosis : What is the probability the measure makes a correct diagnosis. (think about what constitute a correct diagnosis, so not detecting something when there's nothing there would count as well)
Find the velocity v of the block as a function of time : Find the velocity v of the block as a function of time. Express your answer in terms of some or all of the variables: k, m, A, and t. Find the kinetic energy K of the block as a function of time. Express your answer in terms of some or all of the..

Reviews

Write a Review

English Questions & Answers

  Describe a problem using the Elements of Reasoning Model

Describe a problem. This can be a personal or societal problem. Using the Elements of Reasoning Model, describe how you would go about solving this problem.

  Provide at least two scholarly sources from the ashford

read the midas case study of your text. answer questions 1through 4 in a two- to- four page paper in accordance with

  What was the point of the event and how was it communicated

What was the point of this event and how was it communicated? Do you think the production/concert/exhibit effectively achieves its goals?

  Explain the demographic socioeconomic in a nation

As a result of the demographic changes mentioned in our discussion board assignments this week, it is important to note that the faces of our elderly communities have changed dramatically

  Classification of symbiotic relationships

The organism is E. coli, a bacterium that lives in your intestines.

  How love and desire are defined and expressed in the myth

Explain how love and/or desire are defined and expressed in the myth. You may want to use portions of Plato's Symposium to define your terms.

  Rhetorical analysis and logical fallacies

Show what kind of rhetorical analysis and logical fallacies does the film Paris is burning used and why they being used?

  Write an essay paper about emotionally loaded language

Write an essay paper about Emotionally Loaded Language.

  Assess financial performance and condition of organization

Assess the financial performance and condition of the organization

  Write an essay about child labor

Write an essay about Child Labor.

  Question

question..

  Mad professor slips a secret tablet in your food that makes

mad professor slips a secret tablet in your food that makes you grow up as normalbut then remain at that age until you

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