Our Services

Get 15% Discount on your First Order

Section A Input Data

May 7, 2024

Section A

Input Data
				EduCredit is the education loan division of a bank. It is considering a batch of applications for student loans repayable in one year. EduCredit charges each loan applicants an annual interest rate that depends on the band of their credit scores (A is the highest)
Loan Applicant	Maximum Loan requested	Credit Band	Predicted Default Probability
Applicant 1	$10,000	A	1.0%
Applicant 2	$15,000	C	5.8%
Applicant 3	$20,000	B	2.0%
Applicant 4	$8,000	A	1.5%
Applicant 5	$13,000	C	11.0%
Credit Band	Interest Rates			The current batch of applications come from five applicants, each of whom has requested a different loan amount. EduCredit can choose to offer any loan amount up to the maximum amount requested (including zero). Besides the credit scores, EduCredit uses a proprietary predictive analytics model to predict the default probability for each loan applicant based on their previous business history with the bank. All of the above information for the five applicants are listed
A	3.0%
B	4.5%
C	7.0%
D	10.0%
Total Budget	$35,000	Q3-15
	$60,000	Q2
Q1	If EduCredit wants to decide optimally the best amount of loans to offer to each applicant, what should be a reasonable objective to consider?
	To maximize interest revenue minus expected defaulted loan amounts
	To minimize expected defaulted loan amounts
	To maximize interest revenue
	To maximize total dollar amount of loans approved
Q2	If EduCredit has a total budget of $60,000 that it could offer to this batch of applicants, what is optimal decision in terms of the loan amounts to approve for each applicant? Explain briefly [in 30 words or so] how you can find this optimal solution even without using Solver.
Q3	Suppose EduCredit only has a budget of $35,000 for this batch of applications. Formulate the optimization problem on a spreadsheet and solve for the optimal decisions using Solver. Solve for the optimal solution and generate the sensitivity report (for later questions). In Questions 3-7, you will input the optimal loan amounts for each applicant. What is the optimal loan amount to approve for Applicant 1? Enter only the numerical value without dollar sign.
Q4	What is the optimal loan amount to approve for Applicant 2? Enter only the numerical value without dollar sign.
Q5	What is the optimal loan amount to approve for Applicant 3? Enter only the numerical value without dollar sign.
Q6	What is the optimal loan amount to approve for Applicant 4? Enter only the numerical value without dollar sign.
Q7	What is the optimal loan amount to approve for Applicant 5? Enter only the numerical value without dollar sign.
Q8	From the sensitivity report generated from Question 3, how much do we predict the optimal objective value to change if Applicant 4’s requested loan amount is decreased from currently $8000 to $4000. Enter the net change (i.e., include the negative sign if the objective value decreases) without the dollar sign. If we cannot predict based on the sensitivity report, enter -99999.
Q9	From the sensitivity report generated from Question 3, find the shadow price for the budget constraint. Explain [in about 20-30 words] why the shadow price is equal to this value and give an interpretation based on the values of the input data.
EduCredit would like to add the following requirement on the approval decisions: the fraction of loans provided to applicants with credit bands B or below cannot be more than 20% of all loans approved (e.g., if $10000, $4000, $5000 and $6000 are loaned to applicants of bands A, B, C and D, respectively, then the fraction loaned to bands B or below would be (4000+5000+6000)/(10000+4000+5000+6000) = 60%, which violates the requirement). Implement this constraint in your Excel model and re-run Solver.
Q10	What is the optimal loan amount to approve for Applicant 1 after the new constraint? Enter only the numerical value without dollar sign.
Q11	What is the optimal loan amount to approve for Applicant 2 after the new constraint? Enter only the numerical value without dollar sign.
Q12	What is the optimal loan amount to approve for Applicant 3 after the new constraint? Enter only the numerical value without dollar sign.
Q13	What is the optimal loan amount to approve for Applicant 4 after the new constraint? Enter only the numerical value without dollar sign.
Q14	What is the optimal loan amount to approve for Applicant 5 after the new constraint? Enter only the numerical value without dollar sign.
Q15	We have so far assumed that EduCredit can approve any dollar amount up to the maximum amount requested. For example, we can offer Applicant 1 (who applied for $10,000) any amount from $0 to $10,000. For the last question for Section A, suppose EduCredit can only make approve/reject decisions, i.e., if an application is approved, it must be approved in full. For example, Applicant 1 can only be offered $0 or $10,000, but not (say) $5,000. What would happen as we formulate this as an optimization problem and solve it with Solver? Answer without implementing the model. [Select all that apply.]
	We should add integer constraints.
	We should define decision variables that only take values of one or zero
	We should use roundup functions in our decision cells to ensure that, if we approve part of a loan, the full amount must be approved
	We should use the nonlinear solving method
	After Solver solves the problem, it will not generate a sensitivity report

>Business & Finance homework help

Share This Post

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

Related Questions

The company I chose was WorldCom. WorldCom was one of the long-distance scandal accounting company in the country. I truly believe the CEOs and other

The company I chose was WorldCom. WorldCom was one of the long-distance scandal accounting company in the country. I truly believe the CEOs and other corporate officers involved were held responsible because they could lose their job. Stated on the WorldCom Scandal “Employees in the financial and accounting groups believed that

Week8_Test Plan Instructions: The Test Plan for each project includes the Pseudocode, Flowchart, Goals and Objectives, Functional Requirements, and Test

Week8_Test Plan Instructions: The Test Plan for each project includes the Pseudocode, Flowchart, Goals and Objectives, Functional Requirements, and Test Matrix including Actual Output column. Below the table are screenshots verifying the actual output for each case. Note: Your programming projects should be submitted in the Revel environment for grading. Week

In this course, you’ve learned how to draft proposals, find reliable sources, and compose research papers. For this assignment, you will write a

In this course, you’ve learned how to draft proposals, find reliable sources, and compose research papers. For this assignment, you will write a 1500-2000-word research paper based on the prompt below. Since the start of the 21st century, the increasing rate of technological advancement has led to new breakthroughs in computing and

Thumbnails/thumbnail.png Purpose of Assignment: To demonstrate an understanding of recognizing a client in crisis as well as providing education

Thumbnails/thumbnail.png Purpose of Assignment: To demonstrate an understanding of recognizing a client in crisis as well as providing education of crisis intervention techniques, including effective coping mechanisms, for a client in crisis. Instructions: This assignment will require the development of an educational pamphlet. Word or Publisher may be used to

Fixing the proposal: Add proper Gantt chart Change the verbs to reflect future study for Limitations, methadology, data analysis etc. Include a table of

Fixing the proposal: Add proper Gantt chart Change the verbs to reflect future study for Limitations, methadology, data analysis etc. Include a table of content.

Description of your idea: In New York City, many people struggle to find events that match their location and interests.

Description of your idea: In New York City, many people struggle to find events that match their location and interests. They’re tired of scouring the internet, unsure where to look, and often find that the information they find is outdated. Recognizing this need, our entrepreneur has conceived “GoEvent,” an application

How did notions of race influence the U.S. federal government’s relationship with indigenous peoples (Native Americans) within its borders, especially with

How did notions of race influence the U.S. federal government’s relationship with indigenous peoples (Native Americans) within its borders, especially within the context of imperialism and colonialization? In your response, comment on Gross’s articles and Reed’s article from this topic’s readings.

Reflective statement on taking Advanced Health Policy course. Explain 3 things that would make the course great. Explain 2 things that would be an

Reflective statement on taking Advanced Health Policy course. Explain 3 things that would make the course great. Explain 2 things that would be an expectation to improve the course. Describe 1 benefit of taking the course. 2 paragraphs.

Essay II: Personal Reflection on Effective Management Objective: The purpose of this assignment is to encourage students to reflect on their understanding

Essay II: Personal Reflection on Effective Management Objective: The purpose of this assignment is to encourage students to reflect on their understanding of effective management principles and how these insights can be applied to their personal and professional development. Instructions: Introduction: Begin with a brief introduction to the concept of

Discussion on Integrating Sources in APA Instructions:

Discussion on Integrating Sources in APA Instructions: Write a few sentences (120 words) integrating a quote from any of the articles that you will be using in your paper. ( Will post the articles as pdf). Be sure to connect your quote to the rest of your sentences. You can

P rojec t m a n a g e m e n t t e c h niq u e s to m aximise s ucc e s s wi th r e s e a r c h. Ho w a r t h , ML, P ro byn, JE a n d M az, J 1 0.1

P rojec t m a n a g e m e n t t e c h niq u e s to m aximise s ucc e s s wi th r e s e a r c h. Ho w a r t h , ML, P ro byn,

YenRose questions? 1. When comparing the personality theories of Allport, Murray, and Cattell, what are the key similarities and differences between their

YenRose questions? 1. When comparing the personality theories of Allport, Murray, and Cattell, what are the key similarities and differences between their approaches, and how do these theories contribute to our understanding of human personality? Consider their perspectives on personality traits, individual differences, and the methods they employed in their

You are a family nurse practitioner working in an outpatient primary care office of a large hospital system. The practice has been operating for over

You are a family nurse practitioner working in an outpatient primary care office of a large hospital system. The practice has been operating for over 15 years, and many of the administrative and clinical staff were hired when the practice opened. You have been in the practice for less

Assignment: Redemptive Suffering Essay Directions Throughout this course, you have participated in the live

Assignment: Redemptive Suffering Essay Directions Throughout this course, you have participated in the live practice of reflective and empathetic listening related to key topics. In a reflective paper, write a 4–5-page redemptive suffering essay in which you discuss the way in which God uses suffering for his redemptive purposes. In

Rubric for Assignment-3 Logical Data ModelInstructions:Draw a logical data model (ERD) for the Picnics R US case [Refer to ‘Assignment#1’

Rubric for Assignment-3 Logical Data ModelInstructions:Draw a logical data model (ERD) for the Picnics R US case [Refer to ‘Assignment#1’ and‘Assiignment#2’ on Canvas under ‘Assignments’]Rubric: 30% – Identify the entities 15% – Add appropriate attributes for each entity 15% – Assign identifies for each entity 15% – Draw the relationships

see attachment Calibrating Leavitt’s Law QUESTION 1

see attachment Calibrating Leavitt’s Law QUESTION 1 DISTANCE STAR Period (days) log(P) m M 2600 VY Persei 5.37 0.73 8.36 V Persei 5.53 0.74 7.99 VX Persei 10.89 1.04 7.56 SZ Cassiopeiae 13.61 1.13 7.19 QUESTION 2 STAR Period (days) log(P) M EV Scuti 3.09 0.49 -2.9 CE Cassiopaiae A

General Instructions Advanced practice nurses apply continuous quality improvement (CQI) processes to improve client-centered outcomes. Select one of the

General Instructions Advanced practice nurses apply continuous quality improvement (CQI) processes to improve client-centered outcomes. Select one of the following client-centered care initiatives that you would like to improve in your practice area: client clinical outcomes, client satisfaction, care coordination during care transitions, or specialty consultations for clients. Include