Memphis Metro just made a $75,000 purchase from a supplier, subject to the extension of suitable trade credit terms. Because of Memphis Metro’s strong balance sheet and stellar credit rating, the firm’s most recently issued line of credit is priced at 3.65 percent. Calculate the present value of this cash outflow assuming trade credit terms of 30 days; 45 days 60 days Please use Excel to explain, and show the Excel formula.

Q: a. Paradise Retailers, Inc. (PRI) determined that $1,500,000 is needed for cash transactions made…

A: Total cash needed (T) = $1,500,000Fixed charges (F) = $12.95Interest rate (I) = 4.5%

Q: On 1/1, $400,000 of specific accounts receivable of Annie's Animal Shop are assigned as collateral…

A:

Q: The credit analyst for Mazibuko Limited has established the following data relating to the working…

A: Formula for Cash Conversion Cycle  DIO + DSO - DPO WHERE,  DIO= Days of Inventory Outstanding  DSO =…

Q: AB PC Supplies obtains a P5M bank loan at 8% interest compounded semi-annually. The company repays…

A: Loan amount (L) = ₽ 5 million Interest rate (r) = 8% per annum = 4% semiannually Semiannual payment…

Q: Bird's Eye Treehouses, Incorporated, a Kentucky company, has determined that a majority of its…

A: Net present value (NPV) is a financial metric used to assess the profitability of an investment. It…

Q: What is the present value of a stream of 5 end-of-year annual cash receipts of $1,000 given a…

A: Present Value is the Present Worth of cash inflows to be received by the person in the future…

Q: DMT Farms harvests crops in roughly 90-day cycles based on a 360-day year. The firm receives payment…

A: Face Value = Proceeds / [ 1 - ( Discount rate * Period / 360 ) ]

Q: Striker Company estimates its expected cash receipts for the period to be $80,000 and its expected…

A: The objective of the question is to determine how much cash the Striker Company needs to borrow in…

Q: Q6. Suppose you deposit $290,000 into an account that pays 5% interest compounded annually. If you…

A: Annuity refers to the payment series of same nominal value which are paid or received at a same…

Q: using excel, answer the question: An investor takes a loan for $40000 to purchase inventory to…

A: We take loans to buy large ticket items like a car or a house which otherwise we cannot afford. The…

Q: Your boss asks you to compute your company's cash conversion cycle. Looking at the financial…

A: Average inventory$24,800Accounts receivables averaged$18,700Accounts payables…

Q: B. Short term Funds PRINCESS Trading is engaged in the buying and selling of raw materials for sofa…

A:

Q: how to use the excel function (IRR and Effect) to determine which money lender offers a better rate:…

A: Here,

Q: tore offers its salespeople a table with coefficients to be applied to the cash sale value of its…

A: Coefficients are very important in calculating the monthly payments and value of these depends on…

Q: 2. Tortellini Inc. payables policy is being revised. It has an annual overall sales of P50,735,000,…

A: Following is the answer to the given question

Q: STATE FARM Company supplies components to auto repair shops. These shops send their checks via…

A: Given, Receiving time=2 daysProcessing time=2 daysClearance time=24 hours i.e. 1 day Total no. of…

Q: Assume that a firm has a $1,000,000 line of credit at an 4.94 percent rate of interest that requires…

A:

Q: Illustration: A company sells $50,000 of goods with the terms net/30. The receivable is immediately…

A: Sales price = $50,000 Factor fee = 3% Interest = 10% reserve = 8%

Q: A firm has no cash sales (all sales are on credit and are collected 28 days after the sale). If the…

A: Average collection period is one of efficiency ratio which is used in business. This shows time…

Q: The firm's bank charges $18 per wire and $0.50 per EDT. The EDT takes one day longer to clear. The…

A: Since  The minimum transfer balance= TBAL TBAL=Incremental costDS×(K-ECR(1-RRR))365 Where: DS= Days…

Q: Use the present value and future value tables to answer the following questions. Time Value of…

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Q: calculate the present value of this cash outflow assuming trade credit terms of a) 30 days b) 45…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: Westerly Industries has the following financial information. What is its cash conversion cycle?…

A: The cash conversion cycle refers to the number of days required to convert the cash that is spent on…

Q: Bridgette Inc. maintains a cash buffer for unexpected cash outlays for the year amounting to 3,000.…

A: Unexpected annual cash outlay is 3,000 Transaction cost per transaction is P15 Annual interest rate…

Q: A company has decided to purchase equipment, needing to borrow $100,000 from its local bank to make…

A: To calculate the first monthly payment for the 120-month installment note with 8% interest, we can…

Q: Company A is contemplating on borrowing $500,000 to start a business. Credit union 1 has offered to…

A: Time value of money can be defined as a concept which states that the value of a currency declines…

Q: get help with this question please

A: When the effects of compounding over time are taken into account, the effective annual interest rate…

Q: Choose the correct letter and provide solution A firm has total annual sales (all credit) of…

A: To Know in how many days accounts receivable will be collected , we have to calculated average…

Q: A bank lends some money to a business. The business will pay the bank a single payment of $180,000…

A: The present value function can be used to derive the present value of a future sum or the present…

Q: Data on Nathan Enterprises has determined that it needs Php 7.8 million in cash per week. Data on…

A: Economic order quantity model is that inventory model which is used to order the quantity of…

Q: For 2011, Raster Graphics forecasts cash receipts of $405,000 and cash disbursements of $430,000. If…

A: Given that Cash Receipts = $405,000Cash Disbursements = $430,000Beginning Cash Balance =…

Q: 2020 2019 Sales $5,032,000 $4,573,000 Cost of goods sold 2,214,080 2,012,120 Accounts receivable…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: CASH MANAGEMENT 1. Raviolli Enterprise has an average age of accounts receivable is 45 days. The…

A: Since there are multiple questions, we will solve first for you. To get the remaining questions…

Q: A merchant acquires a lot of merchandise with a value of $ 350,000 that he agrees to liquidate by…

A: The present value is the value of the sum received at time 0. It is the current value of the sum…

Q: Solve $140.10 per month; cash price $5,600; down payment $0 Cash or trade months with…

A: Here, To Find: APR =?

Q: Cardo borrowed money from a local cooperative. He received P18,420 but promised to pay P20,000 in…

A: N = 0.5 years Present Value = 18,420 Future Value = 20,000

Q: Paradise Retailers, Inc. (PRI) determined that $1,500,000 is needed for cash transactions made…

A: Baumol model is the cash management model that helps in managing the excess funds by using optimum…