TOPIC: ENGINEERING ECONOMICS and Specific SYSTEMATICALLY. Show your COMPLETE solutions and BOX your final answers. Express all your answers in 2 decimal places. Instructions: Solve each problem NEATLY 1. Gian paid an interest of Php 8000 on a salary loan for 5 years at 7 % interest. What was the original loan? How much did he pay at the end of 5 years?
Q: Gator Fabrics Inc. currently has zero debt (i.e., wd = 0). It is a zero growth company, and additio...
A: Weighted Average Cost of Capital (WACC) is equal to the cost of equity in case of a zero-debt compan...
Q: 4- Consider a project of the Pearson Company. The timing and size of the incremental after-tax cash ...
A: NPV Net present value (NPV) is a capital budgeting tool, which helps to decide on whether the given ...
Q: The TopCar Industries manufactures and sells car components. The current annual sales volume is 500,...
A: Sales volume = 500,000 pieces Selling price = P0.50 Annual fixed expense = P80,000
Q: You invest $1,500 into a "hot stock" through the Robin Hood app. The stock does well in the first qu...
A: We can find the money-weighted return by taking the investment made in the stock $1500 and $1000 and...
Q: The Premiere Company obtained a short-term bank loan for P1,000,000 at an annual interest rate 12%. ...
A: Since you have posted a multi part question therefore as per the guidelines we will be solving the f...
Q: Given: P= Php 450, 500. 50 r= 3 %% t= October 20, 2003 - February 10, 2004 Solve for: _1. Approximat...
A: Actual no of days and Approximate no of days: Actual no of days is calculated by taking actual dif...
Q: You are trying to decide how much to save for retirement. Assume you plan to save $7500 per year wit...
A: Present Value means value of future benefits at the current date. The formula for the same is as fo...
Q: You are considering buying a semi-annual coupon bond with a stated coupon rate of 8 % (note that the...
A: Value of bond = Present value of coupon payments receivable from bond discounted at required rate of...
Q: Based on your understanding of Economic Value per Lead, explain which of the below mentioned channel...
A: Economic Value per lead is the Conversion rate multiply by the average order value from that campaig...
Q: If you deposit $25,000 per year for 13 years (each deposit is made at the end of each year) in an ac...
A: The question is based on the concept time value of money. The future value is defined as the value o...
Q: Using the simple interest formula l= Prt, compute the amount of interest earned on $401.00 at 7.49% ...
A: Investment amount (P) = $401.00 Interest rate (r) = 7.49% Period from Aug 30, 2006 to Dec 28,2006 = ...
Q: JPJ Corp has sales of $1.33 million, accounts receivable of $52,000, total assets of $5.05 million (...
A: Inventory Inventory can be described as a good or material that a company holds for the purpose of r...
Q: Find the optimal risky portfolio if you could only use these two funds, ABC and 123, assume the two...
A: Here, ABC 123 Expected return 0.12 0.15 Standard Deviation 0.2 0.3 Correlation Coeffici...
Q: 1. A Fast-Moving Consumer Goods (FMCG) Company produces certain items at a labor cost of P 115 each,...
A: 1) Let the units for breakeven = X Unit sales price (s) = P 600 Unit variable cost (c) = P 115 + P 7...
Q: Under the Pure Expectations Theory, if issuers expect interest rates to increase, O Two statements a...
A: The Pure expectancy theory explains the term structure of interest rate. The theory explains that fo...
Q: Brett has almond orchards, but he is sick of almonds and prefers to eat walnuts instead. The owner o...
A: Market value of crops = Production in tons x Market price per ton
Q: Credit Card of America (CCA) has a current ratio of 3.5 and a quick ratio of 3.0. If its total curre...
A: Current ratio = 3.5 Quick ratio = 3 Total current assets = $73500
Q: A Corporation believe that it can sell long term-bonds with an 8% coupon rate, although the effectiv...
A: Coupon rate = 8% Effective rate = 10% Tax rate = 35%
Q: Calculating Annuity Values For each of the following annuities, calculate the present value. Annuity...
A: Annuity is a sequence of equal amount of payments made at regular time gaps for a specified period o...
Q: 1. Find the effective rate (APR) for a simple discount note. The maturity value is $10,000 with $148...
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any ...
Q: You invest PHP 100,000.00 in Stock A, PHP 300,000.00 in Stock B. You expect a return of 10% for Stoc...
A: Amount invested in A (A) = Php 100000 Amount invested in B (B) = Php 300000 A's return (Ra) = 10% B'...
Q: TSC, Inc. sells for $24 and pays an annual per share dividend of $2.10, which you expect to grow at ...
A: We will have to use the dividend discount model here.
Q: What does this tell you about total cost when financing for longer periods?
A: Leasing a vehicle refers to driving a car through periodic payments towards the car without actually...
Q: 3. Future Value and Multiple Cash Flows Wells, Inc., has identified an investment project with the f...
A:
Q: Annual deposits were made in a fund earning 10% per annum. The first deposit was Php 20,000 and each...
A: Compounding is a method of charging interest in which Interest is charged on the amount including or...
Q: Based on the information in the tables , which one is the correct Gini coefficient of income inequal...
A: Representing the degree of income inequality in a country graphically is called Lorenz curve. Gini c...
Q: You go to buy a boat and the advertised loan interest rate is 7.72% compounded monthly for 5 years. ...
A: Advertised interest rate = 7.72% monthly compounded
Q: Outline Roll’s critique and explain how this affects the application of the CAPM in practice.
A: Roll's critique suggest or is built on the idea that it is next to impossible to create or observe a...
Q: Determine the present value of a debt of $7000 due in nine months if interest at 2,% is allowed. The...
A: Maturity value (S) = $7000 Interest rate (r) = 2 2/3% = 2.666666666666667% Period (t) = 9 months = 9...
Q: 351,009 ,607,837
A: The notion of present value asserts that a sum of money today is worth more than a sum of money in t...
Q: Elaborate the agency problem on corporation with smaller percentage of individual onwership
A: An agency dilemma is a conflict of interest that exists in every connection in which one person is e...
Q: Solve the following word problems with NEAT and COMPLETE SOLUTIONS. Answers should be rounded off to...
A: The amount of annual scholarship can be found by using the EXCEL PMT function. The formula of the sa...
Q: 4. Vanessa invested k US dollars (USD) in an account that pays a nominal annual interest rate of 2.9...
A: Compounding is a method of charging interest in which Interest is charged on the amount including or...
Q: Boeing is looking to introduce a new jet, the 797, set to be available for purchase in 5 years. Acco...
A: NPV means PV of net benefits which will arise from the project during its life. It is computed by ta...
Q: You have been given the following coupon yield curve: Maturity (years) 1 2 4 Coupon Rate (annual pay...
A: Here, YTM of 2 Year Coupon Bond is 2.31% YTM of One Year Coupon Bond is 1.5% Coupon Rate of Two Year...
Q: Techiefy Co. wants to launch a new product. it is observed that the fixed cost of the new product is...
A: Cost function = 35,000 + 500D Revenue function = 5000D-100 D2 Profit function at breakeven = Reven...
Q: Suzette invested $934.00 in a 95-day term deposit at 7.19% p.a. Using the future value formula, S= P...
A: Invested amount (P) = $934 Period (t) = 95 days = 95/365 = 0.26027397260274 Years Interest rate (r) ...
Q: A bond will be priced at a discount to par value if its coupon rate is less than its yield-to-maturi...
A: Bond prices have an inverse relationship with interest rates, with the price of the current bond fal...
Q: What is the interest earned on a P100,000 investment if it is held for 20 years at 4.3% simple inter...
A: Under simple interest, Total interest per year remains the same and there is no concept of interest ...
Q: The following information showed: State of the Economy Probability of the Sta...
A: Expected return =summation of returns ×probabilities =(13%×20%)+(10%×55%)+(5%×25%) = 9.35%
Q: A Corporation issued preferred stocks for P120 per share. The issue price is P20 more than the stock...
A: Stock price (P) = P120 Annual dividend (D) = P12 Underwriting cost (UC) = P10 Tax rate = 30%
Q: PART II - Below are 2019 FMT Company Cash flow accounts. Increase in bonds 170.0 Net income 117.5 In...
A: Working Notes 1. Net cash provided by (used in) operating activities: Particular Amount Net I...
Q: 9. Calculating Annuity Values If you deposit $5,000 at the end of each year for the next 20 years in...
A: This is the question of the annuity. The future value of annuity has to be computed in this question...
Q: Assume that the risk-free rate is 7.5% and the required return on the market is 10%. What is the req...
A: The question is based on the concept of the capital asset pricing model (CAPM), the model explains t...
Q: During the year, Al's Tools decreased its accounts receivable by $200, increased its inventory by $1...
A: Increase in current assets & decrease in current liabilities results in decrease in cash while d...
Q: You are a banker to Livingstone Thompson Limited, a textile manufacturing company. Livingstone Thomp...
A: Based on the cash flow we will discount the cash flow using the discount rates to find out the net p...
Q: Suppose you held a diversified portfolio consisting of a $7,500 investment in each of 20 different c...
A: Portfolio consists off = 20 stocks Investment of each stock = $7,500 Portfolio beta = 0.95 Selling s...
Q: Are synthetic CDOs a legitimate business investment, or are they pure gambling? If the former, what ...
A: Workplace ethics is concerned with how employees act in the workplace, as well as their morals and a...
Q: The Tomac Swim Club arranged short-term financing of $13,100 .00 on July 5 with the Bank of Commerce...
A: Borrowed Amount is $13,100 Payment on 25 Sept is $5,900 Payment on 11 Nov is $3,400 Balance on 30th...
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.-Carmen Arámbula received her paycheck on August 15 for $23,450.00, and decided to invest it immediately, with a 60-day term, at the end she received $23,918.35. At what annualized interest rate did she invest it? Take the actual year. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. please... understand the context of the exercise in Spanish, it is easy to understand.PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 7.-A car worth $200,000.00 is sold with a down payment of $50,000.00 and the balance in monthly payments over 3 years at an interest rate of 9.5% compounded monthly. Find the value of the monthly payments that the new owner will make. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. please... understand the context of the exercise in Spanish, it is easy to understandSubject: Mathematics in the Modern World (MMW) - Ms. Althea Jordao purchases a home worth Php 1,200,000 with a down payment of 15%. Then she loan the balance from the bank that charges 7.5% annual interest to be paid for 20 years. a. What must be the amount of the mortgage loan? b. What is the monthly mortgage payment? c. How much is the amount of interest paid on the loan over 20 years?
- SUBJECT: ENGINEERING ECONOMICS (a) Identify the Given and the Unknown or what is being asked in the problem (b)Provide the formula to be used (c)Show the complete solution. The final answer is already provided. Maria loaned an amount of 100,000Php payable in 15 equal quarterly instalments. The first payment was made a year after the money was borrowed. How much in each quarterly installments if rate of interest is 10% compounded bi-monthly?Answer: A = 8,706.61PhpPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.-Carmen Arámbula received her paycheck on August 15 for $23,450.00, and decided to invest it immediately, with a 60-day term, at the end she received $23,918.35. At what annualized interest rate did she invest it? Take the actual year. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 1.- Osmara Del Toro deposits her life savings working at HoneyBee for $545,000, for when her retirement day arrives in 6 years, 6 months 6 days. The contract stipulates the payment of interest capitalizable quarterly, at a rate of 10.¼ %. What is the amount she will have at the end of the term that will provide welfare in her old age? Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.
- SUBJECT: ENGINEERING ECONOMICS (a) Identify the Given and the Unknown or what is being asked in the problem (b)Provide the formula to be used (c)Show the complete solution. The final answer is already provided. You plan to deposit P100 into a savings account at the end of each month for the next 5 years. a.)At 3% compounded monthly, how much will you have accumulated at the end of 5 years? b.)How much difference would it make if the payments were made at the beginning of the month rather than at the end? Answer: a.) F = P6,464.67, b.) F value difference = P196.63Please build a spreadsheet in excel and please show all steps and formulas in Excel to solve questions a. through f. and please show any additional calculations please!! Five years ago, Marty purchased a house of $500,000. He borrowed a mortgage with 80% of LTV(loan to value ratio), monthly payments and the interest rate of 5% for 30 years. Marty founda new lender who will refinance the current outstanding loan balance plus all the costsassociated with the new loan at 3.5% with monthly payments for 30 years. Suppose that thenew lender will charge 3.5 discount points on the new loan and other refinancing costs will equal$2,000. a. What is the monthly payment for the current loan?b. What is the current outstanding loan balance?c. What is the new loan amount if he chooses to refinance?d. What is Marty's monthly payment for the new loan?e. What is the effective cost of your new loan if you hold the loan for 30 years? Do yourefinance?f. If Marty wants to refinance today, at least how many…An engineering firm borrowed $500,000 at a 5%/year interest rate. They will repay the loan in 5 years. Calculate the total amount owed in 5 years using simple and compound interest. Show your work/formulas by typing in the textbox.
- enny takes out a new car loan for $41,000 at 5% annual interest rate for 5 years. a. What is Jenny’s monthly payment? Two years later, Jenny has already made 24 monthly payments (of amount calculated in a.) and has 36 remaining payments. What is the remaining principal on the loan? Solve using two methods. b. Solve by calculating the Present Worth of the remaining 36 payments. c. Solve using Excel Spreadsheet function CUMPRINC as discussed on page 165 of text. (note: you should get same answer on b. and c.)The Brown family recently bought a house. The house has a 30 year, $165,000 mortgage with a nominal interest rate of 8 percent. Payments are made at the end of each month. How much will be paid to principal in month 37? Please show formula for solution without using financial calculator or excel. I am using a texas instruments calculator.PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASProblem 5:An account executive at Santander branch CETYS, receives a deposit from an important client-student, surnamed Cuevas Ronchas for $30,000.00; in an account that generates 6% interest, capitalizable monthly. After two years, he decides to make new deposits at the end of each year, so that after three years from this decision, he has $200,000.00 at the time of the last deposit. Find the amount of annual deposits he has to make for the last 3 years. The solution involves calculating a future value and then a present value. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. Please, not in written form, please do it in excel Please, not in written form, please do it in excel Please, not in written…