PV Computations_Worksheet_STUDENTVERSION (3)

In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.

Please provide explanation.

Economics Consider a compounding loan plan where the amounts owed at EOYS 3 and 4 are $5,800 and $6.264, respectively. Approximately, what would be the amount of the loan?

aa.7

if use calculator to do, what number put in CF0=?,CF1,CF2.....

Assume you have the following asset and liability in your Balance Sheet: Asset - Bond A Modified Duration = 2.6 years Value = RM1.5 million Liability - Bond B Modified Duration = 3.1 years Value = RM1.0 million a. Calculate the duration gap.  b. What is the expected change in Net Worth if interest increases by 1%?  c. What should or could you to achieve immunised balance sheet?  Note: Please show all workings.

Toms UI IVesuTment to ychciut ed as a cost of borrowing to compensate the opportunity costs of the bank with I to the cash loaned to you. Moreover, the interest rate is usually expressed as nual percentage rate. activity ctions: On the space provided, write TRUE if the idea being expressed is correct and FALSE if otherwise. 1. In the most loan amortization schedules, amortization of discount or premium of the loan increases over time. 2. The process of obtaining future values is called discounting. 3. An annuity in which cash flows occur at the end of each period is called annuity. age

Question Consider the following balance sheet positions for a financial institution:• Rate-sensitive assets = $120 million; Rate-sensitive liabilities = $180 million.• Rate-sensitive assets = $230 million; Rate-sensitive liabilities = $200 million.a) Calculate the repricing gap and the impact on net interest income of a 2 percent increase in interest rates for each position. b) Calculate the repricing gap and the impact on net interest income of a 2 percent decrease in interest rates for each position.c) Explain the type of risk this FI is exposed to in each position.

Assume you have the following asset and liability in your Balance Sheet: Asset - Bond A Modified Duration = 2.6 years Value = RM1.5 million Liability - Bond B Modified Duration = 3.1 years Value = RM1.0 million a. Calculate the duration gap.  b. What is the expected change in Net Worth if interest increases by 1%? Assume previous interest is 10% c. What should or could you to achieve immunised balance sheet?  Note: Please show all workings.

7 lender appraised value : $8,400,000 cash flow :$444,000  Using Information Above what would be the loan amount assuming a 75% loan-to-value and a 9% debt yield? Round to nearest dollar.

41. After conducting a rate-sensitive analysis, a bank finds itself with the following amounts of rate-sensitive assets and liabilities (RSAS and RSL) and fixed-rate assets and liabilities (FRAs and FRLs); the rate of return and cost rates on the accounts are also given: Assets RSAS @ 4.25% FRAS @ 5.15% NEA Total Amount (Million $) S 322 S 700 S 120 $1,142 Liabilities & Equity RSLS @ 3.11% FRLS @ 4.95% Equity Total If the bank wishes to set up a swap to totally hedge the interest rate risk, the bank should A. pay a variable rate of interest and receive a fixed rate of interest. B. pay a fixed rate of interest and receive a variable rate of interest. Amount (Million $) S 200 $ 800 S 142 $1,142 C. pay a variable rate of interest and receive a variable rate of interest. D. pay a fixed rate of interest and receive a fixed rate of interest.

Solve this practice problem

M4

A Input Area: Interest Income $ Amount of line of credit Term (months) Annualized interest rate on line of crdt Interest Cost Average deposit balance Annualized interest rate on deposit bal Expected Revenues Loan commitment fee (1%) Deposit management fees Wire transfer fees B Fees for agency services Expected Costs Cost of other funds raised Account activity costs Wire transfer costs Loan processing costs Recordkeeping costs Output Area: Expected Revenues Interest income from loan (4%, 9 mo,) Loan commitment fee (1%) Deposit management fees Wire transfer fees Fees for agency services Total Revenues Expected Costs Interest paid on customer deposits Cost of other funds raised Account activity costs Wire transfer costs Loan processing costs Recordkeeping costs Total Costs Total Revenues - Total Costs Before-tax rate of return over costs from the entire relationship C 10,000,000 6 4.00% 2,125,000 2.50% 100,000 4,500 3,500 4,500 180,000 5,000 1,300 12,400 4,500 D E

Help with question g.

Prove the loan payment​ formula, shown below.   PMT=Prn1−1+rn−nt       Question content area bottom Part 1 Manipulate the formula shown below to prove the loan payment formula. The left side of the equation is the future value of the principal amount and the right side is the future value of the loan payments.​ First, solve the equation for PMT.   P1+rnnt  = PMT1+rnnt−1rn

The following loan was paid in full before its due date a) Find the value of h using an appropriate formula b) Use the actuarial method to find the amount of unearned interest c) Find the payoff amount Regular Monthly Payment # of Payments Remaining after Payoff APR 7.2% $247 8 What is the finance charge per $100 financed? h=$ (Round to the nearest cent)

Choose the correct letter and pls provide the solution thanks A firm’s current assets and current liabilities are P1,600.00 and P1,000.00 respectively. How much can it borrow, in a maximum, and on a short-term basis without reducing the current ratio below 1.25? *a. P2,500.00b. P1,000.00c. P1,400.00d. P3,600.00e. P3,500.00

(a) What is base rate ? How it is calculated? (b) State the loan pricing mechanism followed in banks of Bangladesh. (c) Calculate the loan price of Rose Bank under Cost plus Loan Pricing Method. Consider cost of capital is 26% and the borrower belongs to 'Good' Group, hence risk premium for the group is 250 basis point or 2.5 per cent. Particulars Share Capital Reserve Interest & Discount Received... Interest paid on deposits.. Savings Bank Deposit.... Current Deposits.. Fixed Deposits... Bond Issued by Bank Everything with details is already posted in the question. there are no other details

Use Table 9. Assume there is a loan loss of $4. What is the old and new capital ratio? Reserves Loans 17.65%, 11,46% O 17.65%, 12.94% 15.00 %, 11.00% O 15.00 %, 11.46% Table 9 10 90 Deposits Capital 85 15

rive loan is below. Payments of $1,987.26 are made monthly. Payment # Payment 1 1,987.26 2 1,987.26 3 1,987.26 Interest Debt Payment Balance 1,604.17 383.09 1,602.41 384.85 1,600.65 386.61 Provide your answer below: X Y Z Calculate the value of z, the balance of the loan at the end of month 3. Give your answer to the nearest dollar. Do not include commas or the dollar sign in your answer.

Calculate the CAT (total annual cost) for option 1 and then find which option is better to ask for a loan and explain why is it better.   1. Personal Loan         MNL Bank          2.25% simple monthly interest rate         2. Savings Bank CAT= 30% 3. XYZ Bank  CAT= 28.30% 4. 123 Bank  CAT= 26.64%

CENGAGE MINDTAP Ch 07: Assignment - Using Consumer Loans 12. Buy on time or pay cash? You are going to make a substantial purchase. You have enough money to pay cash, but don't know if that's the way to make best use of your assets. Maybe you should take out an installment loan to make the purchase and invest the cash you would otherwise have used to pay for it. Use the information provided to complete the following worksheet and analyze how the numbers work out most favorably for you. For simplicity, compounding is ignored in calculating both the cost of interest and interest earnings. [Note: Enter your dollar answers rounded to the nearest two cents and precede numbers that are less than zero (0) with a minus sign (-).] Q Search this course ? Khloe ✓ A-Z

Hi,how to use the excel function (IRR and Effect) to determine which money lender offers a better rate: 1. Ah Long Finance: Loan amount: $20,000; instalment $600 per month x 36 months  2. Sharky Finance: Loan amount: $30,000; instalment $555 per month x 60 months 3. Ah Beng Finance: Loan amount: 40,000; instalment $ 760 per month x 59 months 4. Barracuda Finance: Loan amount: $50,000; instalment $925 per month x 60 monthsThanks.