Your brother has just taken out a loan for $75,000. The stated (simple) interest rate on this loan is 10 percent, and the bank requires him to maintain a compensating balance equal to 15 percent of the initial face amount of the loan. He currently has $20,000 in his checking account, and he plans to maintain this balance. The loan is an add-on installment loan which he wil repay in 12 equal monthly instaliments, beginning at the end of the first month. What is the approximate average usable funds on this loan? Select one: a. $6,875 b. $20,000 C. $15,000 d. $75,000 e. $37,500

Q: where  is the excel sheet ,so i can see how you get  the answer.  I want to see the workings  please

A: Excel Workings are provided in the solution in the form of Excel snip. One can use the formula…

Q: How would you find FW with excel functions?

A: MARR is 20% EOY Cash Flow 0  $                 -70,000.00 1  $                  20,000.00 2…

Q: will you please show solution without excel step by step

A: As per the given information: Initial salary is $40,000 Salary rise after first year to $44,200…

Q: Describe about the LIFO and FIFO method.

A:

Q: briefly explain what is meant by breakven points

A: Cost accounting is the part of accounting that helps in determining the total cost of production. It…

Q: what excel formula feature would you use

A: Information Provided: Price of bond = $1135.90 Years to Maturity = 10 Annual Yield to Maturity = 8%…

Q: can you show this in excel with the necessary formulas?

A: Trial balance is a worksheet/list of ledger accounts which are sorted into debit and credit…

Q: Which of the following is true of structured data? Select answer from the options below Structured…

A: The objective of the question is to identify the correct statement about structured data from the…

Q: explain hoe blockchains are structured using a block based structure.

A: Deep Dive into Blockchain's Block-Based StructureBlockchains have revolutionized data storage and…

Q: 6, calculate the net present value (NPV) and indicate whether to accept or reject the machine.

A: Calculation of NPV using Excel Function: Excel Spreadsheet:

Q: how do you calculate this question with excel formulas

A: Information Provided: Withdraw amount = $10,000 Interest rate = 6% Years for withdraw $10,000 = 5…

Q: Is there a formula (not in excel) that can be used to calculate this?

A: We can use present value formula and present value annuity factor table to calculate number of…

Q: How do I complete this in Excel spreadsheet

A: Cost in Year 0 The System Cost =-1000000 Delivery and Installation cost=- 100000 Working Capital…

Q: In a data visualization, the vertical axis typically shows __________.   Multiple Choice   values…

A: A column chart will include data labels along the horizontal (X) axis with measured metrics or…

Q: Which of the following is an option for consolidating data into one table or worksheet?

A: The CONSOLIDATE function in Excel is used to combine and aggregate data from multiple worksheets or…

Q: Which function in excel did you use

A: The concept of time value of money will be used here. The amount needed today will be the sum of…

Q: Can you solve using excel and explain the formulas more in depth?

A: Here,Market Cap is 300 billion pesoNext Year FCF is 9.6 billion pesoGrowth Rate is 8.60%

Q: What formula is being used if not using excel?

A: The concept of the time value of money determines that the worth of money gets depreciated over a…

Q: Would you please express the operations without excel. I need to understand it with the actual…

A: The price of stock can be found as the present value of growing dividend in two stages one is…

Q: All the following are reporting views found in Tableau, except: O a. Dashboard. O b. Story. O c.…

A: Tableau is a powerful and versatile data visualization and business intelligence tool that empowers…

Q: What is an important advantage gained by using a spreadsheet?

A: Spreadsheet is an important tool for recording information in the form of rows and columns into…

Q: Could someone please do these calculations by hand? I can't really understand the excel spreadsheet…

A: NPV is defined as the sum of the present values of all future cash inflows less the sum of the…

Q: show in excel form

A: Future value depends on the time and interest rate and due to compounding of interest rate the…

Q: Can you solve it in an Excel spreadsheet? because something is wrong with the asnwer. tyhank you,

A: Bonds are debt instruments issued by companies.The issuing company pays coupons to the bond holders…

Q: Is it possible to get a solution with formulas instead of excel?

A: Money's value depreciates over time, according to the time value of money idea. This is due to the…

Q: Typing clearly urjent

A: To find the smallest value of n>1 for which the left endpoint sum differs from the exact area by…

Q: in management accounting strandard cost ： definition . types of strands and cost . benefit .…

A: Management Accounting: In Management  account or managerial account, directors use information in…

Present Value

Present value (PV) is defined as the current or present value of all future sums of cash flow or money at a specified rate of return. This rate of return is known as the discounted rate, which is essentially the interest rate, discounted over some time. The expected cash flows are discounted at a discount rate to compute the present value. The higher the discount rate, the higher the future value (FV), but the lower the present value.