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.
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: The Transportation Service Directorate of a Municipality wants to purchase a new software system to…
A: Capitalization cost means total cost incurred in the project or investment. Some part of the cost…
Q: A company project needs to establish a fund within a ten-year period by making annual deposits of…
A:
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: Your supervisor has tasked you with evaluating several loans related to a new expansion project.…
A: The present value of annuity refers to the current value of a series of future payments. The present…
Q: A company project needs to establish a fund within a ten-year period by making annual deposits of…
A: Beginning of the year deposits (B) = P 90000 Let the end of the year deposits = X r = 6.2% n = 10…
Q: Park company is building a new office building, and management is trying to decide how rent payments…
A: This question is based on the concept of perpetuity (assuming that the building is let out for a…
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: A group of private investors purchased a condominium complex for $3 million. They made an initial…
A: The loan amount (PV) is $264,000 ($300,000 × (1-12%). The number payments (n) are 56 (14 × 4). The…
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: find the required quarterly payment
A: Cost of condominium = $4 million Down payment = 15% Interest rate = 15% per year Years = 13
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: Spectra Scientific of Santa Clara, CA, manufactures Q-switched solid state industrial lasers for LED…
A: SOLUTION:- Rate of return is the rate of interest paid on unpaid balance of money which is borrowed…
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: re to made to the fund
A: Money Required (Future Value) = 40,000 Present Value (value at start) = 0 N = 3 years Quarterly…
Q: Tennessee Corporation is analyzing a capital expenditure that will involve a cash outlay of…
A: Internal rate of return = Internal rate of return is a discount rate at the the present value of all…
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: A bank offers an investment account that has an annual interst rate of 9.9%, compounded quarterly.…
A: The present value is the value of the sum received at time 0 or the current period. It is the value…
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: Prime Financial Inc. is evaluating two capital investment proposals for a drive-up ATM kiosk, each…
A: The payback period refers to the time period that is required to recover the initial cost. With the…
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: Dawn is preparing a home office to perform subcontract projects for midsized architect firms. She…
A: The MARR (minimum acceptable rate of return) is a rate that is the minimum rate use to evaluate the…
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: The Sampson Company is considering a project that requires an initial outlay of $75,000 and produces…
A: 1) Computation:
Q: The financial manager at Starbuck Industries is considering an investment that requires an initial…
A: Under discounting, cash flows are brought to their present value while under compounding, cash flows…
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: 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: What is the monthly payment? 2) How much of the first payment goes toward interest? 3) How much of…
A: As per company policy, it is only possible to solve the first 3 sub parts of this question.
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: 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: You are an employee of University Consultants, Ltd., and have been given the following assignment.…
A: Computation of various figures is as follows:
Q: For equipment upgrades, a business borrowed $500,000 at 8% compounded semiannually for 5 years. What…
A: Discount rate = 8% x 6/12 = 4% No. of period = 5 years x 12/6 = 10 Semiannual payments = Amount…
Q: Before evaluating the economic merits of a proposed investment, the XYZCorporation insists that its…
A: Cash-Flow diagram shows cash flows that an investment proposal will generate over its life. Cash…
Q: Auckland Corporation has borrowed $700,000 from a bank. Auckland will repay the loan in ten annual…
A: Here, Borrowed Amount is $700,000 Annual Instalments is $100,000 Time Period is 10 years
Q: A group of private investors purchased a condominium complex for $2.5 million. They made an initial…
A: Loan amount = Cost * (1- Down payment) Loan amount = $2,500,000 *(1-12%) Loan amount = $2,200,000
Q: Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000,…
A: Many Thanks for the Question. Bartleby's Guideline “Since you have posted a question with multiple…
Q: The Hub is a business dedicated to providing rentable work spaces for local companies or…
A: Calculate Present value for IBM using the excel formula:
Q: A bank is negotiating a loan. The loan can either be paid off as a lump sum of $140,000 at the end…
A: Using excel PMT function
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Consider the following:purchase of an office building worth P1M from unrestricted funding. Currently, the office building is on a 2 year lease, with rentals of BWP 22000 per month. Provide for recommendations to the finance manager. What what would be the possible effect on the financial health of the organization, if these transactions are approved?Suppose you are a relationship manager at an international bank. A customer who recently got admission at a prestigious Business School approached you for an education loan of Rs. 36,00,000. Your bank offers the education loan at 9.6 percent to be repaid in 10 years in EMIs. You are assigned the task of preparing the amortization schedule for the customer and answer the following. Prepare the amortization schedule for the first 5 EMIs. What will be interest paid for 93th EMI? What will be the loan balance after 93th EMI? What is the total interest paid for the loan?You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following. A realator has a house on sale for $640,000. If possible you believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel. How would you caluclate this in Excel using the PV function? Rate: Nper: Pmt: FV: Type:
- Suppose that your colleague has approached you with an opportunity to lend $25,000 to her laundry business in Accra. The business, called Do it yourself launderette, plans to offer home services to customers at area. Funds would be used to lease a delivery vehicle, purchase supplies, and provide working capital. Terms of the proposal are that you would receive $5,000 at the end of each year in interest with the full $25,000 to be repaid at the end of a ten year period Assuming a 10% required rate of return, calculate the present value of cash flows and the net present value of the proposed investment Based on this same interest rate assumption, calculate the cumulative cash flow of the proposed investment for each period in both nominal and present value terms?Suppose that your colleague has approached you with an opportunity to lend $25,000 to her laundry business in Accra. The business, called Do it yourself launderette, plans to offer home services to customers at area. Funds would be used to lease a delivery vehicle, purchase supplies, and provide working capital. Terms of the proposal are that you would receive $5,000 at the end of each year in interest with the full $25,000 to be repaid at the end of a ten[1]year period. a) Assuming a 10% required rate of return, calculate the present value of cash flows and the net present value of the proposed investment. b) Based on this same interest rate assumption, calculate the cumulative cash flow of the proposed investment for each period in both nominal and present[1]value terms. c) If we are to use the monetary approach to exchange rate determination, what will be the predicted effect on the exchange rate of domestic currency if domestic real income increases? d) Using the same…Complete each requirement on a separate worksheet. Each requirement must have a user input section. Makeup and enter your own numbers for the user inputs for each requirement. Requirements: 1. Create a user input section for the user to input the annual effective interest rate and number of periods per year. Calculate the annual nominal interest rate. 2. The user can invest money at the end of each year. Create a user input section for the user to input the amount that they will invest at the end of each year. Using an annual interest rate of 9%, how much will the user have at the end of 7 years? 3. The user wants to save money to buy a new car 10 years from today. The new car will cost $125,000. Create a user input section for the user to input the amount that they can invest at the beginning of each year. What annual interest rate will they need to earn to have enough cash to buy the car 10 years from today? 4. The user wants to save $60,000.00 for a once in a lifetime…
- Assume that you are nearing graduation and have applied for a job with a local bank. As part of the bank's evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions. Draw time lines for (a) a $2000 lump sum cash flow at the end of year 4, (b) an ordinary annuity of $1000 per year for 5 years, and (c) an uneven cash flow stream of -$450, $1000, $650, $850 and $500 at the end of years 0 through 4. What is the future value of an initial $1000 after 5 years if it is invested in an account paying 5% annual interest? What is the present value of $1000 to be received in 4 years if the appropriate interest rate is 5%? We sometimes need to find out how long it will take a sum of money (or anything else) to grow to some specified amount. For example, if a company's sales for 2020 is $1000 and expected to grow…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 $300,000 beginning in year 2 and ending in year 16. How much will a bank be willing to loan at an interest rate of 13% per year? The bank will be willing to loan the developer a sum of $Assume that you are nearing graduation and have applied for a job with a local bank. As part of the bank's evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions. Draw time lines for: (a) a $2000 lump sum cash flow at the end of year 4, (b) an ordinary annuity of $1000 per year for 5 years, and (c) an uneven cash flow stream of -$450, $1000, $650, $850 and $500 at the end of years 0 through 4.
- As a small software developer firm, you have approached the AXZ Bank to obtain a term loan so that the firm can purchase a new server. The AXZ bank provides two (2) offers to your company, as listed below:a) a loan of $100,000 over a five (5) year period at an interest rate of 7.65% per annum (per year) payable at the end of each month.b) a loan of $100, 000 over a three (3) year period at an interest rate of 5.5% per annum (per year) payable at the end of each month. 1. Calculate the monthly loan instalments for each offer listed above – a) and b).2. Calculate the total interest payments for each offer listed above – a) and b). Please kindly provide all the workings and calculations properly to understand. Thank youA buyer is considering purchasing a 10-acre parcel in Peoria, Arizona for economic development. The parcel has a sales price of $720,000. The buyer agrees with the seller for purchasing the property with 15% down up front and paying off the balance in 12-months. If a bank is willing to provide 3% annual interest, compounded monthly, how much should the monthly deposit be into that account to pay off the desired balance to the seller?Choose the best answer to the following question. Explain your reasoning with one or more complete sentences. What does a loan of $400,000 that carries a 4-point origination fee require as an advance payment? Choose the correct answer below. A. An advance payment of $1,600 is required. Each point is 1% of the loan amount, so the advance payment amount is 4% of $400,000. B. An advance payment of $16,000 is required. Each point is 1% of the loan amount, so the advance payment amount is 4% of $400,000. OC. An advance payment of $8,000 is required. Each point is 1% of the loan amount, so the advance payment amount is 4% of $400,000. OD. An advance payment of $16,000 is required. Each point is 10% of the loan amount, so the advance payment amount is 40% of $400,000. E. An advance payment of $8,000 is required. Each point is 10% of the loan amount, so the advance payment amount is 40% of $400,000. OF. An advance payment of $1,600 is required. Each point is worth between 50 and 100 points…