Reference no: EM131253677
Your company is considering manufacturing protective cases for a popular new smart-phone. Management decides to borrow $200,000 from each of two banks, First American and First Citizen. On the day that you visit both banks, the quoted prime interest rate is 7%. Each loan is similar in that each involves a 60-day note, with interest to be paid at the end of 60 days. The interest rate was set at 2% above the prime rate on First American's fixed-rate note. Over the 60-day period, the rate of interest on this note will remain at the 2% premium over the prime rate regardless of fluctuations in the prime rate. First Citizen sets its interest rate at 1.5% above the prime rate on its floating-rate note. The rate charged over the 60 days will vary directly with the prime rate.
Create a spreadsheet to calculate and analyze the following for the First American loan:
a) Calculate the total dollar interest cost on the loan. Assume a 365-day year.
b) Calculate the 60-day rate on the loan.
c) Assume that the loan is rolled over each 60 days throughout the year under identical conditions and terms. Calculate the effective annual rate of interest on the fixed-rate, 60-day First American note.
Next, create a spreadsheet to calculate the following for the First Citizen loan:
d) Calculate the initial interest rate.
e) Assuming that the prime rate immediately jumps to 7.5% and after 30 days it drops to 7.25%, calculate the interest rate for the first 30 days and the second 30 days of the loan.
f) Calculate the total dollar interest cost.
g) Calculate the 60-day rate of interest.
h) Assume that the loan is rolled over each 60 days throughout the year under the same conditions and terms. Calculate the effective annual rate of interest.
i) Which loan would you choose, and why?
|
Describe how you used the problem solving steps
: Think of an important problem you had to solve during the last few months. - Describe how you used the problem-solving steps discussed in this chapter to resolve the problem.
|
|
What is the bertrand equilibrium
: A Bertrand equilibrium in this environment is a pair of prices (p1 , p2 ) such that, when firm 1 charges p1 and firm 2 sells p2 , neither firm can raise its own profits by unilaterally changing its price. What is the Bertrand equilibrium?
|
|
Benefit from using data from a social networking site
: Identify a problem that would benefit from using data from a social networking site as input to a decision support system. - What difficulties might be encountered in capturing and trying to use this data?
|
|
Determine a key trend that supports the implementation
: From the e-Activity, determine a key trend that supports the implementation of either a community health information network (CHIN) or regional health information organizations (RHINO) in today's health care organizations
|
|
Analyze the first american loan
: Create a spreadsheet to calculate and analyze the following for the First American loan: a) Calculate the total dollar interest cost on the loan. Assume a 365-day year.
|
|
How much goodwill should parma recognize from acquisition
: Firenze Company developed a specialized banking application software program that it licenses to various financial institutions through multiple-year agreements. On January 1, 2014, these licensing agreements have a fair value of $812,500 and represe..
|
|
Salary-increase motion of the current year
: A town council consists of three members who vote every year on their own salary increases. Two Yes Votes are needed to pass the increase. Each member would like a higher salary, but would like to vote against it herself because that looks good to..
|
|
What are the primary inputs and outputs
: Describe the key features of a human resource MIS for a management consulting firm. What are the primary inputs and outputs? What are the subsystems?
|
|
Describe how the system works
: Pick a company and research its human resource management information system. - Describe how the system works. What improvements could be made to the company's human resource MIS?
|