Your supervisor has tasked you with evaluating several loans related to a new expansion project. Using the PVIFA table (table 9.4 in the textbook), determine the annual payment on a $400,000, 8% business loan from a commercial bank that is to be amortized over a five-year period. Show your work. Does this payment seem reasonable? Explain.
Q: A security systems company have been hired to install a system for a city's bank. The city council…
A: Data given: Installation Cost = $40000 Operation Cost = $1000 and increases by $300 each year…
Q: Abeer is a financial manager of a company contemplating two projects and its initial investment for…
A: Payback period is the period (in number of years) in which the initial investment in a project will…
Q: Assume that as a local government financial analyst you are asked to project the feasibility of a…
A: Please recall the formula for compounding.If P is the principal, R is the interest rate, N is the…
Q: BRCC is evaluating two options for funding its working capital during the next year. Option one is…
A: a) Option 1: Money to borrow = Fund need / (1 - Rate*180/365) / (1 - Compensating balance) + $5000…
Q: Halls Construction is analyzing its capital expenditure proposals for the purchase of equipment in…
A: Capital budgeting decisions are the decisions that are taken by a corporation in relation to a…
Q: Assuming that you would like to buy an equipment for your small business. Using the information…
A: Internal rate of return is the discount rate where the present value of inflows is equal to the…
Q: The Business Manager of a Commercial Laboratory needs to determine the present value of a $170,000…
A: Formulas: Future value= Present value *(1+rate)^years
Q: BRCC is evaluating an option for funding its working capital during the next year. The company plans…
A: in this we have to calculate the interest and add to that to get required value.
Q: In annual general meeting of TNB Liberty Power limited, it is decided that the company will make…
A: Given Information Cost of Laser-based plant =$1,000,000 Interest rate =10% Loan repaid in 10 years…
Q: The management of Niagra National Bank is considering an investment in automatic teller machines.…
A: There are number of projects evaluated on the basis of capital budgeting technique. One of the…
Q: Halls Construction is analyzing its capital expenditure proposals for the purchase of equipment in…
A: Halls Company would compute the payback period for projects A, B, and C. The project(s) having the…
Q: A contractor is constructing a project for which he will be paid in one lump sum upon satisfactory…
A: Loan for the first 6 months=$700,000 , interest rate = 1.5% per month for the first 10 month Loan…
Q: Answer the following questions related to Dubois Inc. a. Dubois Inc. has $600,000 to invest. The…
A: As you posted multiple questions we are answering only first question kindly repost the unanswered…
Q: An IT company receives two new project proposals. Project A will cost $250,000 to develop and is…
A: Project A Cost = $ 250,000 Annual cash inflow = $50000 Project B Cost = $ 350,000 Annual cash…
Q: engineering company expects to expand its plant facilities in 6 years at an estimated cost of…
A: a) Solved using Financial Calculator N = 6 years * 4 = 24 I/Y = 10%/4 = 2.5% FV = 68,000 CPT PMT =…
Q: assume that the bank decided to give a loan of $ 59 million to Nivea Corporation (recorded for the…
A: Introduction: The payback period is nothing but how long it takes to recoup the cost of an…
Q: Calculate the IRR of the previous project. Justify for what type of discount this investment will be…
A: Internal Rate of Return: It is the rate at which the project's net present value is equal to zero.…
Q: Galvanized Products is considering the purchase of a new computer system for their enterprise data…
A: Before the investing money in new assets, profitability and return from that asset is computed. This…
Q: 1. Assume that as a local government financial analyst you are asked to project the feasibility of a…
A:
Q: Use Excel to solve the following problem. Assume that as a local government financial analyst you…
A:
Q: An FI is planning the purchase of a $4 million loan to raise the existing average duration of its…
A: a-1 Duration of assets = Duration of loan 1 * weight of loan in asset + duration of other assets *…
Q: Your company has been presented with an opportunity to invest in a project. The facts on the project…
A: Time Period = 10 Years Rate of return = 15% Initial Investment PHP 5,00,00,000.00 Gross…
Q: Your supervisor has tasked you with evaluating several loans related to a new expansion project.…
A: Solution: Annual payment on Loan = $450,000 / Cumulative PV factor at 8% for 5 periods = $450,000 /…
Q: he required investment cost of a new, large shopping center is $52 million. The salvage value of the…
A: Given, Investment=$52million Salvage value=$18million Project life=18 years Annual operating…
Q: Look at the following outlays and identify whether each is normally considered a capital expenditure…
A: Operating expenses are the expenses that are generally incurred during regular business operations.…
Q: You have an opportunity to acquire a property from First Capital Bank. The bank recently obtained…
A: The question is based on the concept capital budgeting decision , by ues of present value of concept…
Q: You have an opportunity to acquire a property from First Capital Bank. The bank recently obtained…
A: Property Costs $ 2,00,000.00 Acquisition related expenses $ 10,500.00 Repair…
Q: Timber Plc have identified a 5-year capital investment project and are preparing a schedule of cash…
A: Cashflows The movement of money in the business is known as cash flow. The money moves in and out of…
Q: A road is constructed at the capital cost of $10 million. At the end of Year 10, major improvements…
A: Annualized Cost refers to equivalent cost that is incurred on project on annual basis. It is…
Q: You are currently working in a construction company. Your company have been appointed to a…
A: b). Design A Year Returns Discounting factor Inflow 1 290000 0.909 263610 2 290000 0.826…
Q: assume that the bank decided to give a loan of $ 59 million to Nivea Corporation (recorded for…
A: Net present value (NPV) is the difference between the present values of cash inflows and cash…
Q: A commercial real state developer plans to borrow money to finance an upscale mall in an exclusive…
A: Firstly, calculate the present value of annuity for 14 years at rate of 10% Present value of annuity…
Q: Consider the following:purchase of an office building worth P1M from unrestricted funding.…
A: If the company choose to take the asset out on lease, then the company has to make a payment towards…
Q: Greater Findlay Development Consortium is preparing to open a new retail strip mall and have…
A: Discount rate is 12% To Find: NPV PI IRR
Q: You are the financial manager of the firm LAB.inc which does research in the medical field, your…
A: Given, The yearly payments $100,000
Q: An engineer has been offered an investment opportunity that will require an immediate cash outlay of…
A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…
Q: Wilson Bryant Air Conditioning, a Middle Georgia HVAC company, wanted to build a web-based project…
A: Interest rate = 14% N = 5 years Loan = 5,000,000 Profit in year 2 - 4 = 1,500,000 80% of profit will…
Q: Galvanized Products is considering purchasing a new computer system for their enterprise data…
A: 1. Computation of loan amount. Amount of loan = 100000 × 25% = 25000 Loan including interest = 25000…
Q: Galvanized Products is considering the purchase of a new computer system for its enterprise data…
A: Purchase price= $100000 Salvage value= $5000 Maintenance expenses= $25000/ year Savings due to…
Q: a) To upgrade its vehicles, the project Insignia is considering undertaking, the company is…
A: The loan is repaid by making monthly payment which means the interest on loan is compounding on…
Q: A local municipality is considering investing $270,000 to upgrade a park. Based on similar…
A: Interest rate =6% Present value FACTOR =1-(1+r)-n/r Present value FACTOR =1-(1.06)-7/0.06 Present…
Q: You are an employee of University Consultants, Limited, and have been given the following…
A: Debt coverage ratio = ( Net Operating income / Debt Service)
Q: HydroKlean LLC, an environmental soil cleaning company, borrowed $3.5 million to finance startup…
A: Net present value is the technique used in capital budgeting to evaluate the acceptability of the…
Q: Cargojet Corp. is preparing for the replacement of one of its jets in three years by making payments…
A: The question is based on the concept of sinking fund to accumulate the required amount at end . The…
Q: Galvanized Products is considering the purchase of a new computer system for its enterprise data…
A: Present value computes the existing value of future benefits by discounting future worth with a…
- Your supervisor has tasked you with evaluating several loans related to a new expansion project. Using the PVIFA table (table 9.4 in the textbook), determine the annual payment on a $400,000, 8% business loan from a commercial bank that is to be amortized over a five-year period. Show your work. Does this payment seem reasonable? Explain.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments, together with annual rates of return, are as follows: The credit union will have 2 million available for investment during the coming year. State laws are credit union policies impose the following restrictions on the composition of the loans and investments: Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the 2 million be allocated to each of the loan/investment alternatives to maximize total annual return? What is the projected total annual return?Using the information provided, what transaction represents the best application of the present value of an annuity due of $1? A. Falcon Products leases an office building for 8 years with annual lease payments of $100,000 to be made at the beginning of each year. B. Compass, Inc., signs a note of $32,000, which requires the company to pay back the principal plus interest in four years. C. Bahwat Company plans to deposit a lump sum of $100.000 for the construction of a solar farm In 4 years. D. NYC Industries leases a car for 4 yearly annual lease payments of $12,000, where payments are made at the end of each year.Your supervisor has tasked you with evaluating several loans related to a new expansion project. Using the PVIFA table, determine the annual payment on a $450,000, 8% business loan from a commercial bank that is to be amortized over a five-year period. Show your work. Does this payment seem reasonable? Explain.
- The committee decided to secure a loan of $2,400,000 for the overall project. They got two offers from banks. - MC bank - pay in 24 months, $100,000 p/month of repayment, at an annual simple interest rate of 5% for the total loan - CS bank - pay in 16 months, $150,000 p/month of repayment at, an annual compound interest rate of 6% for the total loan The committee needs to decide which bank they should go with. So, they hired you as their financial advisor. 4. Create two amortization tables showing Payment number, Payment, Interest, Principal Reduction , Balance and total payments for Simple interest and Compound interest. 8. The city expects the population in the Residential Infrastructure area to grow exponentially at a rate of 2% per year. a. Calculate the projected population after 10 years if the current population is 50,000 (define a recurrence relation to answer this question). b. Draw a graph illustrating the population growth over 10 years. The city planning committee is…The committee decided to secure a loan of $2,400,000 for the overall project. They got two offers from banks. - MC bank - pay in 24 months, $100,000 p/month of repayment, at an annual simple interest rate of 5% for the total loan - CS bank - pay in 16 months, $150,000 p/month of repayment at, an annual compound interest rate of 6% for the total loan The committee needs to decide which bank they should go with. So, they hired you as their financial advisor. 4. Create two amortization tables showing total payments for Simple interest and Compound interest. 5. Based on your calculations in Question 4, as the company financial advisor, which bank offer are you going to choose for the loan? 6. The Green Spaces project involves purchasing equipment worth $300,000. Assuming a flat rate depreciation of 10% per year, calculate the book value of the equipment after 4 years (define a recurrence relation to answer this question).You are considering purchasing a lot adjacentto your laundry business to provide adequate parking space for your customers. You need to borrow$75,000 to secure the lot. You have made a deal with alocal bank to pay the loan back over a five-year periodwith the following payment terms: 14%, 20%, 26%,32%, and 38% of the initial loan at the end of first,second, third, fourth, and fifth years, respectively.(a) What rate of interest is the bank earning fromthis loan?(b) What would be the total interest paid over thefive-year period?
- Please teach me how to solve this, thanks! ABC would like to hire two loan collectors to speed up its collection process. Each of the loan collectors will be given total annual benefits of P150,000 per year. The entity earns P30,000,000 in sales, 10% of which are cash. The entity has a 365-day year and a minimum required rate of return of 10%. The current average age of receivables is 70 days but with the loan collectors, it is forecasted to decrease by 30 days. How much is the net benefit or (cost) of this option?A commercial real estate developer plans to borrow money to finance an upscale mall in an exclusive area of the city. The developer plans to get a loan that will be repaid with uniform payments of $400,000 over a 15-year period beginning in year 2 and ending in year 15. How much will a bank be willing to loan at an interest rate of 10% per year?The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenue-producing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union will have $2 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments: Risk-free securities may not exceed 30% of the total funds…
- Answer the following complete solution: The committee decided to secure a loan of $2,400,000 for the overall project. They got two offers from banks. - MC bank - pay in 24 months, $100,000 p/month of repayment, at an annual simple interest rate of 5% for the total loan - CS bank - pay in 16 months, $150,000 p/month of repayment at, an annual compound interest rate of 6% for the total loan The committee needs to decide which bank they should go with. So, they hired you as their financial advisor. 4. Create two amortization tables showing total payments for Simple interest and Compound interest. 5. Based on your calculations in Question 4, as the company financial advisor, which bank offer are you going to choose for the loan? Justify your answer. 6. The Green Spaces project involves purchasing equipment worth $300,000. Assuming a flat rate depreciation of 10% per year, calculate the book value of the equipment after 4 years (define a recurrence relation to answer this question). 7.…Let's say you are a credit analyst in the asset management department of a large bank or insurance company. The credit department is researching an investment in a syndicated loan made to a large firm. The loan is an “amortized loan” with a 7% interest rate payable semi-annually. The original term was 10 years. For analytical purposes, assume the loan trades in $1000 increments. What are the semi-annual payments on the loan? * PLEASE USE EXCEL AND SHOW WHAT FUNCTIONS/FORMULAS YOU USED*An FI is planning the purchase of a $4 million loan to raise the existing average duration of its assets from 4.8 years to 6.3 years. It currently has total assets worth $20 million, $4 million in cash (0 duration), and $16 million in loans. All the loans are fairly priced. a-1. Assuming it uses the cash to purchase the loan, calculate the duration of the existing loan. a-2. Assuming the FI uses the cash to purchase the loan and that the loan has a 8.3 year duration, calculate the resulting duration of the asset portfolio. a-3. Should it purchase the loan if its duration is 8.3 years?b. What asset duration loans should it purchase in order to raise its average duration to 6.3 years?