Question

In: Accounting

Please show work: Minnesota Financial is a subsidiary of Mayberry Enterprises. Processing loan applications is the...

Please show work:

Minnesota Financial is a subsidiary of Mayberry Enterprises. Processing loan applications is the main task of the corporation. They charge a $500 fee for every loan application processed. Next year's fixed costs have been projected as follows: sales and advertising $40,000; building rental, $18,000; Depreciation of computers and office equipment $27,000; and other fixed costs, $5,000. The projected variable costs include: loan officer’s wages, $27 per hour (a loan application takes 5 hours to process); supplies $16.40 per application; and other variable costs, $8.60 per application. (Round all answers to the closest full number)

Questions:

1. Determine the number of loan applications the company must process to (a) break even and (b) earn a profit of $50,000 (round to the closest full number).

2. Determine the number of loan applications the company must process to earn a target profit of $50,000 if fixed costs increase by $10,000.

3. Assuming the original fixed cost information and assuming that 500 loan applications are processed, compute the loan application fee the company must charge if the target profit is $75,000.

4. If 750 loan applications is the maximum number her staff can handle. How much more (less) can be spent on promotional costs if the highest fee tolerable to the customer is $600, if variable costs cannot be reduced, and if the target net income for such an application load is $100,000?

Solutions

Expert Solution

Total fixed costs = 40000+18000+27000+5000 = $            90,000
Variable costs per application = 27*5+16.40+8.60 = $ 160
Contribution margin per application = 500-160 = $ 340
1]
a] Number of application to break even = Fixed costs/CM per application = 90000/340 = 265 applications
b] Contribution margin required to earn a profit of $50000 = 50000+fixed costs = 50000+90000 = $         1,40,000
Number of applictions required to earn $50000 profit = 140000/265 = 528 applications
2] Number of applications required = (90000+10000+50000)/340 = 441 applications
3] Total contribution margin required = 75000+90000 = $         1,65,000
CM required per application = 165000/500 = $ 330
Sale price required per application = CM per application+variable cost per application = 330+160 = $ 490
4] Maximum revenue = 750*600 = $         4,50,000
Less: Target net income $         1,00,000
Total costs permitted $         3,50,000
Less: Total variable costs = 750*160 = $         1,20,000
Maximum allowable fixed costs $         2,30,000
Less: Existing fixed costs $            90,000
Maximum possible additional promotional costs $         1,40,000

Related Solutions

The commercial loan operation of a financial institution has a standard for processing new loan applications...
The commercial loan operation of a financial institution has a standard for processing new loan applications in 24 hours. Table below shows the number of applications processed each day for the last 20 days and the number of applications that required more than 24 hours to complete. (can you please send me the excel file for this problem? Thanks) the question is Draw the chart to see if the system is in control or not? I am not exactly sure...
Please show all work. Thank you! The amount of money requested on home loan applications at...
Please show all work. Thank you! The amount of money requested on home loan applications at America Bank follows normal distribution, with a mean of $180,000 and a standard deviation of $6,000. A loan application is received this morning. a) What is the probability the amount requested is $190,000 or more? b) What is the probability the amount requested is between $178,000 and $190,000? c) What is the probability the amount requested in below $178,000? d) How much is requested...
PLEASE SHOW ALL WORK. 2. A bank is negotiating a loan. The loan can either be...
PLEASE SHOW ALL WORK. 2. A bank is negotiating a loan. The loan can either be paid off as a lump sum of $100,000 at the end of five years, or as equal annual payments at the end of each of the next five years. If the interest rate on the loan is 10% regardless of the payment method, what annual payments should be made so that both forms of payment are equivalent? 3. You have an investment opportunity that...
Derivative Applications Please show any necessary work on the following problem: In February 2017 the price...
Derivative Applications Please show any necessary work on the following problem: In February 2017 the price of a daily pass to drive on a Volusia County beach was $10, and at that price 26,467 passes were sold.  In February 2018 the price of a daily pass rose to $20, and the number of passes sold dropped to 17,994.  What is the elasticity of demand for the parking pass?  Is the demand elastic, inelastic, or unit elastic?  Explain the meaning of your answer in the...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications for a number of regional builders. Home buying and therefore mortgage processing is a highly seasonal business, and requires temporary staff during busy processing periods. Holmes hires staff on a monthly basis from two different temporary staffing firms - Professional Temps (PT) and Support on Demand (SD). In June, Empire hired 14 staff members from PT and 10 from SD. PT is a more...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications...
Adam Holmes is the Processing Manager of Empire Mortgage Company, a firm that processes loan applications for a number of regional builders. Home buying and therefore mortgage processing is a highly seasonal business, and requires temporary staff during busy processing periods. Holmes hires staff on a monthly basis from two different temporary staffing firms - Professional Temps (PT) and Support on Demand (SD). In June, Empire hired 14 staff members from PT and 10 from SD. PT is a more...
**Please, Show work and Formula in excel sheet** Your initial loan amount is $200,000. The APR...
**Please, Show work and Formula in excel sheet** Your initial loan amount is $200,000. The APR is 5%. The number of years of the loan is 20 years. Generate the amortization table for the given loan. Assume this is the mortgage on your house. If you elected to pay an additional principal amount of $150.00 each month, in how many months would you pay off your mortgage? Not considering taxes, how much would you save in interest paid to service...
PLEASE SHOW WORK FOR EACH ANSWER 2. Loan Amortization . James wants to buy a house...
PLEASE SHOW WORK FOR EACH ANSWER 2. Loan Amortization . James wants to buy a house worth $1,000,000. To do so, he takes out a mortgage loan equal to the price of the house. The mortgage has to be repaid after 15 years and make monthly payments with an APR of 10%. Given this information, answer the following (a) . Draw the timeline that describes all cash flows (paid and received) throughout the duration of the loan. On the timeline,...
Please show how to work this problem? In some applications, nickel-cadmium batteries (EMF= 1.30 V) have...
Please show how to work this problem? In some applications, nickel-cadmium batteries (EMF= 1.30 V) have been replaced by nickel-zinc batteries. The overall cell reaction for this new battery is: 2H2O (l) + 2NiO(OH) (s) + Zn (s) --> 2Ni(OH)2 (s) + Zn(OH)2 (s) a) What is the cathode half reaction? b) What is the anode half reaction? c) What voltage would you expect the nickel-zinc battery will produce?
(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond...
(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond with $1,000 principal, 20-year maturity, and 8% coupon (annual payments). Yields on comparable bonds are 10%.   Bob expects that two years from now, yields on comparable bonds will have declined to 9%. Find his expected yield, assuming the bond is sold in two years. 3. Calculate the duration of a $1,000, eight-year zero coupon bond using annual compounding and a current market rate of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT