Credit, Debt, and Finance

To solve this question, the user needs to know the financial functions in Excel and their respective parameters. The user must be familiar with the concept of a loan and its components, such as the principal, interest rate, and term.

Option A: The Pay function is not a recognized financial function in Excel. Therefore, option A is incorrect.

Option B: The Pmt function returns the periodic payment required to pay off a loan, given the interest rate, number of payments, and loan amount. This is the correct function to use for calculating the monthly payments of a loan. Therefore, option B is the correct answer.

Option C: The FV function is used to calculate the future value of an investment or loan, given the interest rate, number of payments, and periodic payment amount. Therefore, option C is incorrect.

Option D: The FV function is used to calculate the future value of an investment or loan, given the interest rate, number of payments, and present value. Therefore, option D is incorrect.

Option E: None of the above functions exist in Excel. Therefore, option E is incorrect.

The answer is: B. Pmt (Rate, Nper, PV)

NINJA is an acronym used in mortgage lending to describe high-risk borrowers with No Income, No Job, and No Assets. These subprime loans were prominent during the 2008 financial crisis because lenders extended credit without verifying borrowers' ability to repay. Option A is incomplete, and Option B misses the 'No Assets' component.

Sub-prime lending refers to lending to borrowers with less-than-ideal credit status or higher credit risk (Option 1). It does NOT refer to high-value customers (Option 2) or non-regular customers (Option 3). Sub-prime borrowers typically have lower credit scores and higher default risk, which is why these loans carried higher interest rates and contributed to the 2008 financial crisis.

Negative equity occurs when the outstanding loan balance exceeds the current market value of the asset securing the loan. This is common in underwater mortgages where home prices have fallen below the mortgage amount. The borrower owes more than the asset is worth, making it difficult to sell without loss.

Long-term liabilities are obligations due after more than one year. A bank loan repayable in three years is a classic example of long-term debt financing. The other options (bank overdraft, accruals, dividends payable) are typically current or short-term liabilities due within 12 months.

A grace period is the time during which you can pay your credit card balance in full without incurring any finance charges or interest. It typically lasts 21-25 days from the statement closing date, not from the due date (which would describe a late fee period).

A secured credit card requires a cash deposit that becomes your credit line, acting as collateral for the account. This allows people with poor or no credit to build credit history, as the bank takes minimal risk since they can keep your deposit if you default.

A credit card margin is the spread added to an index rate (like Prime Rate) to determine the APR. A 3-point margin means the APR is 3 percentage points above the reference index rate, not about differences between purchase/cash advance rates or minimum payment percentages.

Revolving credit means you can borrow repeatedly up to your credit limit as you make payments, with interest charged on the outstanding balance. Unlike installment loans, it's not about APR changes tied to Prime Rate or penalty rates for late payments.

Variable APRs can be pegged to various benchmark rates including Prime, Treasury Bill, or Federal Reserve Discount rates. The card agreement specifies which index plus margin are used, so all three are valid bases for determining your rate.

Debentures are long-term debt instruments issued by companies to raise capital, typically with maturity periods of 10-20 years. They represent long-term borrowing, not short-term obligations like sundry creditors.

Feeder Finance Loans are short-term loans specifically designed for purchasers of feeder cattle - livestock purchased for fattening before slaughter. The term 'feeder' refers to the animal's purpose (to be fed for finishing), and these loans are typically short-term because the feeding cycle is relatively brief compared to other agricultural loans.

Feeder Finance Loans are short-term lending instruments for buyers acquiring feeder cattle - livestock being raised for meat production rather than work or breeding. The loan term aligns with the feeding cycle. Options B and D incorrectly state long-term, while A refers to plougher (work animals).

CRR stands for Cash Reserve Ratio - the fraction of deposits banks must maintain with RBI. It's a monetary policy tool, not related to repo rates or currency reserves.

Factor payments are payments made to the factors of production (land, labor, capital, entrepreneurship) for their productive services. Interest paid to a bank for a crop loan is payment for capital, hence a factor payment. The other options (tractor, electricity, tools) are intermediate consumption expenditures, not factor payments.