Business

FinanceQ&A LibraryUse Excel to solve the following problem. Assume that as a local government financial analyst you are asked to project the feasibility of a loan to a proposed public service venture for its start-up funding. The venture’s principals estimate that, at the end of 5 years, they will be able to pay back up to $800,000 from revenues accruing to the venture’s activities. Assuming that your organization’s current “average cost of capital” is 4.8% (the “discount rate”). Assuming monthly compounding, what is the maximum amount your government can commit to the venture for its start-up? (I have worked this problem out on my own, I just want to be sure I used the correct formulas.)Start your trial now! First week only $4.99!*arrow_forward*

Question

Use Excel to solve the following problem. Assume that as a local government financial analyst you are asked to project the feasibility of a loan to a proposed public service venture for its start-up funding. The venture’s principals estimate that, at the end of 5 years, they will be able to pay back up to $800,000 from revenues accruing to the venture’s activities. Assuming that your organization’s current “average cost of capital” is 4.8% (the “discount rate”). Assuming monthly compounding, what is the maximum amount your government can commit to the venture for its start-up? (I have worked this problem out on my own, I just want to be sure I used the correct formulas.)

Tagged in

Business

Finance

Find answers to questions asked by students like you.

Q: What is the net present value of a project with the following cash flows if the required rate of ret...

A: Net Present Value (NPV)NPV is the method of evaluating the worth of an investment or project by dedu...

Q: Multinational companies are exposed to complex management and allocation of their resources. A multi...

A: Question 1:Calculate the change in the dollar value of inventory:

Q: Globalization has led to the progressive integration of capital markets around the world, allowing w...

A: South Korean wons are deposited in a bank in Brazil : Eurocurrency DepositsEurocurrency is the term ...

Q: You borrowed $700 at 5% compounded quarterly. Yourpayments are $150 at the end of each year. How man...

A: We will adopt the following approach:It's a typical time value of money case, where we have to find ...

Q: a. Use the appropriate formula to determine the periodic deposit. b. How much of the financial goal ...

A: Given: Rate = 6.75% compounded monthlyTime = 45 yearsFinancial goal = $1,000,000Using formula for fu...

Q: Simone's Sweets is an all-equity firm that has 9,100 shares of stock outstanding at a market price o...

A: As is situation: All equity, no debt, hence no interest payment, Let T be the tax rate.Hence, Pre ta...

Q: I've been studying simulations. Not sure if you'll be able to answer this question from the informat...

A: For a call option, if the strike price of the option is 52, and the underlying stock is trading at a...

Q: Your firm is offered credit terms of 1/10, net 35. What is the effective annual interest rate on thi...

A: Calculating the value of effective interest rate on the credit terms. We have,Effective interest rat...

Q: USE THE INFORMATION BELOW FOR THE FOLLOWING PROBLEM Stock Rit Rmt ai Beta C 12 10 0 0.8 ...

A: Abnormal return = Return in excess of market return in the given period = Rit - RmtFor stock C, the ...

Q: Larry's Bank buys 58 bonds of the Puppet House Corp. through a broker. The bonds pay 10 percent ann...

A: Part A.Characteristics of the bond:Payment frequency = Semi annual, Period = Half year.Periodic coup...

Q: A firm has the following investing alternative: Cash Inflows Year ...

A: Since the question has multiple sub parts, I will address the first five sub parts. Please post the ...

Q: The following companies have different financial statistics. Texas Burgers Tom's Hot Dogs Gr...

A: Texas Burgers:It has got projects that can lead to healthy growth of 22% in sales and earningsLimite...

Q: Bonds of Francesca Corporation with a par value of $1,000 sell for $960, mature in five years, and h...

A: We have :Fac Value of the bond : $1,000Current Market Price : $960Years to Maturity : 5 yearsCoupon ...

Q: How I RESOLVE THIS PROBLEM Sun instrument expects to issue new stock at $34 a share with estimated f...

A: Calculation of cost of retained earnings:

Q: The four different bond ratings below have a yeild to maturity for 10 year bonds. Baa 9.40% Ba1 9.60...

A: The bonds of Parrot Corp. were rated as Baa and issued at par a few weeks ago. The yiled correspond...

Q: Mobray Corp. is experiencing rapid growth. Dividends are expected to grow at 28 percent per year dur...

A: Dividends: The term dividends allude to that portion of proceeds of an organization which is circula...

Q: Consider the following trading and performance data for four different equity mutual funds: ...

A: Part (a)Portfolio turnover ratio = Last year's security sale / Asset under management.Please see th...

Q: Your company has been approached to bid on a contract to sell 21,000 voice recognition (VR) computer...

A: As per the details provided in the question, following are the required calculation where selling pr...

Q: What is the value of a 30-year annuity that pays $2500 a year? The annuity’s first payment will be r...

A: As a fist step, let's shifts ourselves to the end of t = 10 years.Annuity, A = $ 2,500; n = number ...

Q: You just won the lottery. You and your heirs will receive $40,000 per year forever, beginning 10 yea...

A: PV today, of a perpetuity starting a year from now is given by = P / r where P = perptuity amount an...

Q: Gulf Shores Inn is comparing two separate capital structures. The first structure consists of 315,00...

A: Calculating the price per share of equity of the company. We have,Let the price of equity share be X...

Q: Kose, Inc., has a target debt-equity ratio of 1.31. Its WACC is 8.1 percent, and the tax rate is 22 ...

A: Kose, Inc., has a target debt-equity ratio of 1.31. Its WACC is 8.1 percent, and the tax rate is 22 ...

Q: Please help do this calculation step by step I have problems getting the final answer.

A: Calculating the value of weighted-average cost of capital (WACC). We have,WACC = (Weight of Equity x...

Q: Can I have this explained? Am confused. Now you have $20,000 in your savings account in which you ea...

A: Calculation of Quarterly Interest Rate:

Q: Boulder Furniture has bonds outstanding that mature in 13 years, have a 6 percent coupon, and pay in...

A: Calculation of Yield to Maturity:Excel Spreadsheet:

Q: The Analysis and Valuation of Bonds, Investment Analysis and Portfolio Management1. The following ta...

A: a.Calculate the one-year implied forward rate as follows:

Q: Compute the nominal annual rate of interest for the simple annuity due. Future value: - Present valu...

A: Calculation of Nominal Annual Rate of Interest:The Nominal Annual Rate of Interest can be calculated...

Q: Inzaghi Company recently hired you as a consultant to estimate the company’s WACC. You have obtained...

A: WACC is the weighted average cost of capital. The same can be calculated as:WACC = Wd x Kd x (1 - T)...

Q: A firm has two possible investment with the following cash inflows. Each investment cost $480, and t...

A: Upon visula Inspection, we can deduce that investment A will have shorter payback period (<2 year...

Q: The following problem refers to the stock table for ABC Inc. (a tire company) given below. Use the...

A: Hi, I’m answering the first 3 subparts of the question as the given question consists of multiple su...

Q: Lantech investor is deciding between two bonds: Bond A pay $72 annual interest and has a market val...

A: Since you have asked multiple sub parts in the question, I will address the first three sub parts. P...

Q: At the end of each quarter-year, for 6 years, $1,200 is deposited into an investment paying 3.4% int...

A: At the end of each quarter-year, for 6 years, $1,200 is deposited into an investment paying 3.4% int...

Q: Here are the percentage returns on two stocks. Digital Executive Month Cheese Fruit January February...

A: Variance:Variance is a valuation of difference in each stock from the mean of stocks. It shows how a...

Q: Block, S., Hirt, G., & Danielsen, B. (2017). Foundations of Financial Management. New York, NY: ...

A: Part (A)City Farm has $5 million per day in collections and $3 million per day in disbursementsColle...

Q: An auto plant that costs $100 million to build can produce a line of flexfuel cars that will produce...

A: a)-1Calculation of expected NPV:

Q: Please can you show me how to solve for P step by step thank you

A: Click to see the answer

Q: Better Mousetraps has developed a new trap. It can go into production for an initial investment in e...

A: Calculation of Increase in Project NPV:

Q: Tomneed to have $15,000 in five years to pay offa home equity loan. If Tom were to invest in an acco...

A: Tom needs $15000 in 5 years. He has to make one deposit now that will get an interest of 5.75% compo...

Q: The prices of a certain security follow a geometric Brownian motion with parameters mu=.12 and sigma...

A: Let's pull together all the variables of Black Scholes Model:S = Current stock price = 40K = Strike ...

Q: Assume Technical Investors is thinking about three different size offerings for issuance of addition...

A: The percentage underwriting spread for each size offer is calculated as follows:Percentage underwrit...

Q: Participation #6: Why is it desirable to construct capital budgeting rules so that higher-risk pro...

A: A risk is a probability of unfavorable outcome. All investments are subjected to risks. So, a high ...

Q: An individual wishes to borrow $10,000 for a year and is offered the following alternatives: a. A 10...

A: Calculating the effective interest rate on borrowing option 10% loan discounted in advances. We have...

Q: You own 230 shares of stock in Halestorm, Inc., that currently sells for $83.20 per share. The compa...

A: Cum dividend price, P0 = $ 83.20Dividend per share, D = $ 3.30No taxesHence, ex dividend price, Px =...

Q: A firm evaluates all of its projects by applying the IRR rule. The required return for the following...

A: Calculation of IRR:Using Excel Spreadsheet:

Q: The credit card with the transactions described in the popup below uses the average daily balance me...

A: Credit CardIt is a card issued to customers for making payment towards goods and services. These car...

Q: Laura is saving for the college education of hertwochildren. They are two years apart in age; one wi...

A: As a first step let’s plot the cash flows on a time diagram.Please see the white board. In the table...

Q: Relative inflation rates affect interest rates, exchange rates, the overall economic health of a cou...

A: Answer 1:The statement is a “valid” statement.Justification: The interest rate may comprise two segm...

Q: AJ’s Market generally holds $50,000 in cash in case an unexpected investment opportunity arises. Thi...

A: AJ’s Market generally holds $50,000 in cash in case an unexpected investment opportunity arises. Thi...

Q: Participation #5: Think about the cash flows associated with putting in the bank for five years, as...

A: Let's recall that IRR of any businessproject is nothing but that discount rate at which present valu...

Q: can I have this explained? After 20 years, 100 shares of stock originally purchased for $1000 was so...

A: The formula to calculate the yield on investment:Yield on investment can be determined using the CAG...