### Our Services

Get 15% Discount on your First Order

# Please help with problem set need done by 3/27 11:59 pm 1 ACFI 450 Application Problem Set 3 Spring 2024 Due 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

### Please answers all the questions in the excel file according to the instruction i have provided and then provide me with the excel file with all the

Please answers all the questions in the excel file according to the instruction i have provided and then provide me with the excel file with all the answers. I really need help!

### I need some help!  Part 1 Discussion Question 1. How would you describe the basic components of WACC to a group of decision

I need some help!  Part 1 Discussion Question 1. How would you describe the basic components of WACC to a group of decision makers in a company? 2. On the most basic level, if a firm’s WACC is 12 percent, what does this mean? 3. In calculating the WACC, if

### Please Access the “Ch Worksheets – Raw” file from this Module, Re-Save it using your name, and complete the Textbook Exercises. A demonstration video has

Please Access the “Ch Worksheets – Raw” file from this Module, Re-Save it using your name, and complete the Textbook Exercises. A demonstration video has been uploaded to guide you through this homework. Please Complete all the Problems in the associated Excel template (even the ones demonstrated in the video).

### In the fast-paced business world, maintaining a competitive edge often hinges on accessing the right talent at the right time. This is where staff

In the fast-paced business world, maintaining a competitive edge often hinges on accessing the right talent at the right time. This is where staff augmentation shines as a strategic solution.  To explore how staff augmentation can elevate your business operations, visit Sombrainc:    and discover tailored solutions designed to drive

### Analyze and define the problem to include possible political conflicts. Identify risks and challenges. Identify and construct policy alternatives and

Analyze and define the problem to include possible political conflicts. Identify risks and challenges. Identify and construct policy alternatives and solutions. Identify stakeholders and key roles. Identify funding opportunities, challenges, and budget cost factors; including saving measures. Select supportive and evaluative criteria. Identify incentives, subsidies, and potential benefits. Draw

### Provide a real public policy issue (local, state, or national) and select an appropriate criterion for policy prescription to use in deciding the

Provide a real public policy issue (local, state, or national) and select an appropriate criterion for policy prescription to use in deciding the policy’s effectiveness, efficiency, and adequacy. Provide some reasons why you selected the criterion (such as importance, application, or relevancy).

### Identify and discuss the six principles of control activities. Suggest the two most important principles for an online retail business versus a

Identify and discuss the six principles of control activities. Suggest the two most important principles for an online retail business versus a brick-and-mortar retail business. Provide support for your rationale.

### A MNC which has gone through an international stock market financing or international public debt market financing in the past 5 years, conduct a

A MNC which has gone through an international stock market financing or international public debt market financing in the past 5 years, conduct a comprehensive analysis on the decision making rational and provide an in-depth discussion about the related financial/business environment.

### 1 1 Foundational Concepts and Issues of Positive Psychology: The What and Why of Happiness I don’t think that my positive psychology story is

1 1 Foundational Concepts and Issues of Positive Psychology: The What and Why of Happiness I don’t think that my positive psychology story is all that unusual. In the mid-1990s I was happily engaged with investigating memory biases in depression (e.g., Watkins, 2002; Watkins, Martin, & Stern, 2000), but had

### Discussion 1.1 and 1.2 Respond to the following two discussion posts. Due 4/19/2024

Discussion 1.1 and 1.2 Respond to the following two discussion posts. Due 4/19/2024 A Prayer over You Kathryn     Prayer is such a powerful thing. I think praying for someone is one the most powerful things you can do for another. Prayer is my time where I feel like

### · Address the following prompts. · Prompt 1: In the section “Taking the Project Management Route”, the team is developing a schedule for

· Address the following prompts. · Prompt 1: In the section “Taking the Project Management Route”, the team is developing a schedule for the overall project. Discuss how a network diagram might come in handy for this task. What does the critical path have to do with this approach? Use

### Problem Set #7 Attached Files: ·  Building a Model – Marvel

Problem Set #7 Attached Files: ·  Building a Model – Marvel Renovations.xlsx  (18.835 KB) Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the

### Can you calculate GMPV for the attached EXCEL sheet  This file is too large to display.View in new window

Can you calculate GMPV for the attached EXCEL sheet  This file is too large to display.View in new window

### · Also, upload the work files from R (LastName_FirstName.r), separeated for Part 1,2 and 3. Excel is not suitable for this project and it will not

· Also, upload the work files from R (LastName_FirstName.r), separeated for Part 1,2 and 3. Excel is not suitable for this project and it will not be accepted. You must follow my code submission guideline. THERE IS NO EXCEPTION or PARTIAL CREDIT if you fail to comply. 1.  You MUST use

### This is a synthesis of research and common themes should form your supporting paragraphs

This is a synthesis of research and common themes should form your supporting paragraphs

### Given the resultant damage to the Astros brand, what actions should the team take to recover from the crisis and repair its reputation?

Given the resultant damage to the Astros brand, what actions should the team take to recover from the crisis and repair its reputation?

### See attached Spring Flowers 58 ● First, you will review a current Classroom Assessment SEE ATTACHED Student data 1 & 2 ●

See attached Spring Flowers 58 ● First, you will review a current Classroom Assessment SEE ATTACHED Student data 1 & 2 ● Next, you will organize your data in a data chart. ● Lastly, you will write a thorough reflection using the prompts below. Please ensure that your reflection is

### working on class project BUS 400 Project Guidelines and Rubric Competencies In this project, you will demonstrate your mastery of the following

working on class project BUS 400 Project Guidelines and Rubric Competencies In this project, you will demonstrate your mastery of the following competencies: · Determine how an organization gains a competitive advantage · Determine organizational risk and growth opportunities in order to develop a strategic plan · Defend business decisions