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.)

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.)

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Related Finance Q&A

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...