# Please help with problem set need done by 3/27 11:59 pm1ACFI 450 Application Problem Set 3 Spring 2024Due by 11:59 PM on Monday, March 27,

1

ACFI 450 Application Problem Set 3 Spring 2024

Due by 11:59 PM on Monday, March 27, 2024

Record your responses to the questions in a Word or PDF file named YourLastName_APS3. For this

problem set, you should also submit an Excel file, named YourLastName_APS3, that contains your

calculations. Your Excel file SHOULD NOT CONTAIN WRITTEN RESPONSES; it should ONLY CONTAIN

CALCULATIONS. Your responses should be free of grammar, spelling, and punctuation errors. Upload

and submit your file(s) using the Application Problem Set 3 drop box by the deadline.

1. An insurance company has issued \$675,000,000 in short-term notes with a 1-year maturity to

finance the purchase of \$675,000,000 short-term investments with a 6-year maturity. The insurance

company must pay 6.7% annual interest on the notes but earns 7.5% annual interest on the

investments.

a. Calculate the insurance company’s profit spread and dollar value of profit at the end of Year 1.

(5 points)

b. Calculate the insurance company’s profit spread and dollar value of profit at the end of Year 2 if

the insurance company must issue short-term notes on which it must pay that 7.1% annual

interest. (5 points)

c. What type of interest rate risk is the insurance company facing due to the different maturities

on its assets and liabilities? Why is this a concern to the insurance company? (3 points)

2. A bank has the following balance sheet. The loans have a 3-year maturity and earn 7.9% annually.

The interest is paid once a year and the principal will not be repaid until maturity. The securities do

not earn interest. The certificates of deposit (CDs) have a 1-year maturity. The bank must pay 5.4%

on the CDs.

Assets Liabilities & Equity

Cash \$480,000 Demand deposits \$750,000

Loans 2,960,000 Certificates of deposit 2,960,000

Securities 1,300,000 Equity 1,030,000

Total Assets \$4,740,000 Total Liabilities & Equity \$4,740,000

a. What is the net interest income (NII) for the bank at the end of the first year? (4 points)

b. Suppose that interest rates are expected to increase by 50 basis points (0.5%) at the end of the

first year. What will the NII be at the end of the second year? (4 points)

c. If interest rates change as expected, the value of the bank’s loans will decrease in value to

\$2,933,752. What will happen to the market value of the bank’s equity? Why? (3 points)

2

3. Given the following balance sheet, analyze the bank’s interest rate risk by answering the questions

below. Dollars are in millions.

Assets Liabilities and Equity

Cash \$ 6.57 Demand deposits \$ 34.77

1-month T-bills (5.55%) 25.88 6-month CDs (3.92%) 35.87

6-month T-bills (5.24%) 15.90 1-year CDs (4.5%) 38.76

10-year T-bonds (3.95%) 49.42 2-year CDs (2.95%) 21.43

5-year business loans (7.44%) 104.86 5-years CDs (3.00%) 56.87

7-year business loans (6.95%) 75.33 Long-term debt (5.15% fixed rate) 144.55
20-year mortgages, floating rate

(6.12%, reset every 6 months) 112.65 Equity 68.76

Premises 10.40

Total Assets \$ 401.01 Total Liabilities and Equity \$ 401.01

a. Calculate the bank’s net interest income (NII). (8 points)

b. Calculate (i) the one-year repricing gap (CGAP) and (ii) the gap ratio for the bank. (6 points)

c. Use the repricing gap model to estimate the change in net interest income (ΔNII) if interest rates

are expected to decrease by 125 basis points next year. Assume that the spread between rates

on assets and liabilities remains constant. (3 points)

d. Estimate ΔNII if interest rates on rate-sensitive assets decrease by 110 basis points and interest

rates on rate-sensitive liabilities decrease 140 basis points. (4 points)

e. Why are the answers in c. and d. different? How do these estimates represent the CGAP effect

and the spread effect? Explain. (3 points)

4. Suppose a bank has financed a \$11,000,000 10-year loan with an annual coupon rate of 8.34% with

a 15-year \$11,000,000 bond with a semiannual coupon rate of 6.76%. The yield on the loan is 8.55%

and the yield on the bond is 6.32%.

a. Calculate the (i) duration and (ii) modified duration for the loan. (7 points)

b. Calculate the (i) duration and (ii) modified duration for the bond. (7 points)

c. If market interest rates decrease 150 basis points, estimate the effect on the market value of the

bank’s equity from this arrangement. (6 points)

5. An insurance company owns a 30-year Treasury bond with a 4.75% coupon rate. The bond has a

\$100,000 face value and pays its coupon semiannually. Its duration is 16.7891, current market price

is \$107,700 and its current yield to maturity is 4.29%. The insurance company is concerned that

interest rates may increase by 82 basis points. Treasury bond futures on the same bond are

currently available with a price of 119.56.

a. If interest rates rise by 82 basis points, what will be the impact on the insurance company’s

Treasury bond value? Will it increase or decrease in value? By how much? Support your answer

with appropriate calculations. (4 points)

b. If the insurance company hedges its position in the Treasury bond with a Treasury future, what

position should it take in the future? Why? (3 points)

3

c. Suppose interest rates rise by the expected 82 basis points and the insurance company has

hedged its position as you recommend in b. Calculate the net value of the hedge after the

increase in interest rates. (6 points)

6. A financial institution currently uses a base rate of 6.5%, charges an origination fee of 0.88% and

requires a compensating balance of 15%. The Federal Reserve imposes a 10% reserve requirement

on the bank’s demand deposits. For a customer with a 4.9% risk premium, calculate the bank’s ROA

on the loan. (6 points)

7. A bank is considering a loan applicant for a \$13,500,000 6-year loan. The servicing fee is expected to

be 110 basis points and the bank’s cost of funds, its RAROC benchmark, is 11.5%. The estimated

maximum change in the borrower’s risk premium is 3.7%. The loan’s duration is 4.5743 years and

current market interest rates for similar loans is 14.0%. Based on the RAROC model, should the bank

make the loan? Why or why not? (10 points)

Order a Similar Paper and get 15% Discount on your First Order

## Related Questions

### There are three compliance templates posted in reading assignments this week. As a model, they do not contain the name of financial institution, unit, or a

There are three compliance templates posted in reading assignments this week. As a model, they do not contain the name of financial institution, unit, or a person responsible for the compliance reporting or in charge of the compliance policy and procedure. Please download each of the three templates  Please review

### Attached please read a legal case regarding credit card fraud. Please provide a summary of the case Please identify all legal statutes US DOJ applied to

Attached please read a legal case regarding credit card fraud.  Please provide a summary of the case Please identify all legal statutes US DOJ applied to prosecute the case Please highlight prevention techniques identified in the textbook or PPT lecture Please discuss which technique is most effective in this legal case

### Please answer the questions with at least 250 words 4 in text citations and 4 references 1.At what stage in a company’s life cycle is its structure most

Please answer the questions with at least 250 words 4 in text citations and 4 references 1.At what stage in a company’s life cycle is its structure most likely to begin driving its strategy? Why? How do business leaders align structure and strategy most effectively at this stage of the

### Ngăn ngừa trầy xước thấu kính thủy tinh Hướng dẫn toàn diệnThấu kính thủy tinh thường được sử dụng trong nhiều thiết bị quang học khác nhau nhưng chú

Ngăn ngừa trầy xước thấu kính thủy tinh Hướng dẫn toàn diện Thấu kính thủy tinh thường được sử dụng trong nhiều thiết bị quang học khác nhau nhưng chúng dễ bị trầy xước và có thể ảnh hưởng đến hiệu suất của chúng. Hiểu nguyên nhân của những

### Show the process of solving each problem. The answer is already provided.   Chapter 14:  Work, Energy, and Power · Section: Problems · 14-56 A

Show the process of solving each problem. The answer is already provided.    Chapter 14:  Work, Energy, and Power · Section: Problems · 14-56 A gear with a mass moment of inertia of 0.45 kg⋅m2 has a kinetic energy of rotation of 21 joules. What is its speed of rotation in

### Show the process of solving each problem. The answer is already provided. Plane Motion If a rigid body moves with both translational and

Show the process of solving each problem. The answer is already provided.  Plane Motion If a rigid body moves with both translational and rotational motion, it is said to be in general plane motion. To analyze general plane motion, equations describing the translation of the center of gravity and the

### Show the process of solving each problem. The answer is already provided.  Review Assignment Kinetics Kinetics, the study of unbalanced forces

Show the process of solving each problem. The answer is already provided.   Review Assignment Kinetics Kinetics, the study of unbalanced forces causing motion, can be analyzed by three methods: inertia force or torque (dynamic equilibrium), work and energy, and impulse and momentum. Consider the following as you complete your assignment:

### Write a research  in the form of an argumentative on a topic of your choosing that is explicitly or implicitly related to race and public policy

Write a research  in the form of an argumentative on a topic of your choosing that is explicitly or implicitly related to race and public policy

### Please answer the questions with at least 250 words 4 in text citations and 4 references 1.At what stage in a company’s life cycle is its structure most

Please answer the questions with at least 250 words 4 in text citations and 4 references 1.At what stage in a company’s life cycle is its structure most likely to begin driving its strategy? Why? How do business leaders align structure and strategy most effectively at this stage of the

### I am looking for someone to help me solve the attached question image1.png

I am looking for someone to help me solve the attached question  image1.png

### write a speech about this topic for civilization’s class   WRITE IT AS FAST AS YOU CAN AND USE THE ARTICLE I HAVE UPLOADED The Cold War. (1945-1991) The

write a speech about this topic for civilization’s class   WRITE IT AS FAST AS YOU CAN AND USE THE ARTICLE I HAVE UPLOADED The Cold War. (1945-1991) The Cold War was reflected in culture through music, movies, books, television, and other media, as well as sports, social beliefs, and behavior.

### Give an example of a study that would aid your work or findings by testing a hypothesis. Give an idea of the variable whose value you

Give an example of a study that would aid your work or findings by testing a hypothesis. Give an idea of the variable whose value you think would be tested and how you would go about estimating its value. If the null hypothesis is rejected, the finding could alter your

### See attached docExecutive Summary Presentation With Speaker Notes Overview For the final project in this course, you will

See attached doc Executive Summary Presentation With Speaker Notes Overview For the final project in this course, you will develop an  executive summary presentation with speaker notes. Imagine that you are a human resource professional in an organization that is struggling with a conflict regarding a critical strategic project. Leaders in

### Key Assignment Draft Part 1 Craft a 1 page memo. Make sure to include the following points in the memo: Explain how legal barriers may or may not prohibit

Key Assignment Draft Part 1 Craft a 1 page memo. Make sure to include the following points in the memo: Explain how legal barriers may or may not prohibit information sharing at the different levels o Key Assignment Draft Part 1 Craft a 1 page memo. Make sure to include

### Please choose a group that we’ve not discussed yet. In essay form, address the following issues:A brief overview of this group’s American history. A

Please choose a group that we’ve not discussed yet. In essay form, address the following issues: A brief overview of this group’s American history. A brief overview of this group’s treatment in the United States. Why would you define this group as a “minority”? What is this group’s relationship with

### INSTRUCTIONS- · Answer the five (5) quiz questions below. Answer questions that · Provide an evidence-based rationale for each of your answers to

INSTRUCTIONS- · Answer the five (5) quiz questions below. Answer questions that · Provide an evidence-based rationale for each of your answers to the five (5) questions.   · Provide a citation and matching reference is required from the course textbook for each of the five (5) rationales.  Textbook name provide below

### ADVOCATING FOR THE NURSING ROLE IN PROGRAM DESIGN AND IMPLEMENTATION As their names imply, the honeyguide bird and the honey badger both share an

ADVOCATING FOR THE NURSING ROLE IN PROGRAM DESIGN AND IMPLEMENTATION As their names imply, the honeyguide bird and the honey badger both share an affinity for honey. Honeyguide birds specialize in finding beehives but struggle to access the honey within. Honey badgers are well-equipped to raid beehives but cannot always

### THE ROLE OF THE RN/APRN IN POLICY-MAKING Word cloud generators have become popular tools for meetings and team-building events. Groups or teams are a

THE ROLE OF THE RN/APRN IN POLICY-MAKING Word cloud generators have become popular tools for meetings and team-building events. Groups or teams are asked to use these applications to input words they feel best describe their team or their role. A “word cloud” is generated by the application that makes