Use the exact interest method (365 days) and the ordinary interest method (360 days) to compare the amount (in $) of interest for the loan. Principal 10,000,000 Rate % 10 Time (days) 1 Exact Interest Ordinary Interest

Use the exact interest method (365 days) and the ordinary interest method (360 days) to compare the amount (in $) of interest for the loan. Principal 10,000,000 Rate % 10 Time (days) 1 Exact Interest Ordinary Interest

Name: Use the exact interest method (365 days) and the ordinary interest met
Uploaded: 2022-11-23T16:32:22.000Z
Channel: Bartleby
Description: Use the exact interest method (365 days) and the ordinary interest method (360 days) to compare the amount (in $) of interest for the loan.Principal 10,000,000Rate % 10Time (days) 1Exact InterestOrdinary Int

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 38P: Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly...

See similar textbooks

Similar questions

It is January 1 of year 0, and Merck is trying to determine whether to continue development of a new drug. The following information is relevant. You can assume that all cash flows occur at the ends of the respective years. Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year 1 or 2. There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow the drug to be marketed. The cost of clinical trials is assumed to follow a triangular distribution with best case 100 million, most likely case 150 million, and worst case 250 million. Clinical trial costs are incurred at the end of the year clinical trials are completed. If clinical trials succeed, the drug will be sold for five years, earning a profit of 6 per unit sold. If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of the plant is assumed to follow a triangular distribution with best case 1 billion, most likely case 1.5 billion, and worst case 2.5 billion. The plant cost will be depreciated on a straight-line basis during the five years of sales. Sales begin the year after successful clinical trials. Of course, if the clinical trials fail, there are no sales. During the first year of sales, Merck believe sales will be between 100 million and 200 million units. Sales of 140 million units are assumed to be three times as likely as sales of 120 million units, and sales of 160 million units are assumed to be twice as likely as sales of 120 million units. Merck assumes that for years 2 to 5 that the drug is on the market, the growth rate will be the same each year. The annual growth in sales will be between 5% and 15%. There is a 25% chance that the annual growth will be 7% or less, a 50% chance that it will be 9% or less, and a 75% chance that it will be 12% or less. Cash flows are discounted 15% per year, and the tax rate is 40%. Use simulation to model Mercks situation. Based on the simulation output, would you recommend that Merck continue developing? Explain your reasoning. What are the three key drivers of the projects NPV? (Hint: The way the uncertainty about the first year sales is stated suggests using the General distribution, implemented with the RISKGENERAL function. Similarly, the way the uncertainty about the annual growth rate is stated suggests using the Cumul distribution, implemented with the RISKCUMUL function. Look these functions up in @RISKs online help.)
a.Use the appropriate formula to find the value of the annuity. b.Find the interest. Periodic Deposit Rate Time $6000 at the end of each year 5.5% compounded annually 20 years Click the icon to view some finance formulas. a.The value of the annuity is $_______. (Do not round until the final answer. Then round to the nearest dollar as needed.) b.The interest is $________. (Use the answer from part (a) to find this answer. Round to the nearest dollar as needed.)
It is important to get the bank to grant you the loan you need. What do you think the bank will consider before granting it if it only had to focus on one thing? Of the three alternatives, which one do you consider to be the most relevant for the bank? a. sales volume b. confirming that the sum of the expected profit after taxes plus depreciation exceeds the annual repayment. c. Ensuring that profit before interest and taxes is approximately 5% of sales
The usual face value for most corporate bonds is $5,000.; True or False
Evaluate the following statements:S1. Any investment income of general borrowing is deducted from capitalizable borrowing cost.S2. If the asset is financed by specific borrowing but a portion is used for working capital purposes, the borrowing shall be treated as general borrowing in determining capitalizable borrowing cost. a.False, False b.False, True c.True, True d.True, False
The company's bank won't lend it any more money than it already has, and investment bankers have said that debentures are out of the question. The treasurer has asked you to do some research and suggest a few ways in which bonds might be made attractive enough to allow the company to borrow. Please provide a detail explanation for numbers 1-4. 1. Explain how to secure the bonds with owned assets in great detial. In what ways does it make the bonds more attractive to allow the company to borrow? 2. What is the agreement to subordinate future debt? How does it make the bonds more attractive? 3. What does providing a restrictive indenture limiting the risk in future undertakings do? How does it make the bonds more attractive? Explain in great detail. 4. How does providing a sinking fund for principal repayment make the bonds more attractive? Explain in detail.
Please answer along with the excel formulas - 1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? $205.83 $216.67 $228.07 $240.08 $252.08 2. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? $1,781.53 $1,870.61 $1,964.14 $2,062.34 $2,165.46 3. Last year Rocco Corporation's sales were $225 million. If sales grow at 6% per year, how large (in millions) will they be 5 years later? $271.74 $286.05 $301.10 $316.16 $331.96
You are managing a portfolio of $1 million. Your target duration is 11 years, and you can choose from two assets: a zero coupon bond with maturity 5 years, and a perpetuity, the yield is: A. .688 B. .417 C. .583 D. .312
Straight commercial loans are basically important to cover up working capital needs for a period of time like 30 to 90 days. ‌True False
aren Johnson, CFO for Raucous Roasters (RR), a specialty coffee manufacturer, is rethinking her company’s working capital policy considering a recent scare she faced when RR’s corporate banker, citing a nationwide credit crunch, balked at renewing RR’s line of credit. Had the line of credit not been renewed, RR would not have been able to make payroll, potentially forcing the company out of business. Although the line of credit was ultimately renewed, the scare has forced Johnson to examine carefully each component of RR’s working capital to make sure it is needed, with the goal of determining whether the line of credit can be eliminated entirely. In addition to (possibly) freeing RR from the need for a line of credit, Johnson is well aware that reducing working capital can also add value to a company by improving its EVA (Economic Value Added). In her corporate finance course Johnson learned that EVA is calculated by taking net operating profit after taxes (NOPAT) and then subtracting…
In the context of capital budgeting, risk refers toSelect one: a.the chance that the internal rate of return will exceed the cost of capital b.the degree of variability of the initial investment. c.the degree of variability of the cash inflows. d.the chance that the net present value will be greater thanzero.
Your Finance Department makes sure your company has the financial resources it needs to run through the year. The department can raise money via one-year bank notes, 10-year bonds or stock issues.O TrueO False