skip to Main Content

I’m working on a Excel question and need support to help me understand better.SH

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Learn More button at the bottom of the page to get started.

I’m working on a Excel question and need support to help me understand better.SHOW ALL OF YOUR WORK/TURN IN EXCEL SOLUTIONS1. Vito’s Tavern had $262,000 in 2019 taxable income. What is the taxable income? (5 Points)2. During the year, Vito’s Tavern had gross sales of $1,200,000. Costs of Goods sold was $672,000, selling and administrative expenses were $212,000. Vito Tech also had notes payable (liability) of $750,000 at an interest rate of 3%. Depreciation was $110,000 and the company is in a 35% tax bracket. What is Vito Tech’s net income and operating cash flow? (10 Points)3. The most recent financial statements for Vito’s Tavern are as follows:Income StatementSales $55,000Costs $40,000Taxable Income $15,000Taxes (28%) $4,200NI $10,800Balance SheetCurrent Assets $40,000 Long-Term Debt $60,000Fixed Assets $100,000 Equity $75,000Total $140,000 Total $135,000Assets and costs are proportional to sales. Beakman maintains a 10% dividend payout ratio and a constant debt-equity ratio. What is the maximum increase in sales that can be sustained assuming no new equity is issued? (10 Points)4. If Vito’s Tavern has a ROE of 10% and a payout ratio of 7%, what is its sustainable growth rate? (8 Points) 5. PNC Bank pays 5% simple interest on its savings account balances, whereas First Niagara Bank pays 5% interest compounded annually. If you made a deposit of $20,000 in each bank, how much money would you earn from both bank accounts at the end of 10 years? (10 Points)6. Compute future value for the following: (6 Points)Present ValueYearsInterest RateFuture Value$7,5521015%$94,0001812%$250,00057%
7. Compute Present Value for the following: (6 Points)Present ValueYearsInterest RateFuture Value1010%$17,3452012%$1,753,300408%$5,135,0008. Suppose you would like to buy your dream house in 10 years. You estimate that you will need $50,000 for the down payment. If you believe your mutual fund can achieve 7% annual rate of return and you want to have the down payment for the house in 10 years, how much do you have to invest today? (5 Points) 9. You have just made a one-time $5,000 contribution to your retirement account. Assuming you earn 15% per year and make no additional contributions. What will your account be worth when you retire in 40 years? (5 Points) 10. You receive $5,000 per year for the next 20 years from your Grandmother’s trust. If a 7% interest rate is applied, what is the present value of the future payment? (5 Points) 11. If you deposit $5,000 per year for the next 20 years into an account paying 10%, how much money will you have in the account in after the 20 years? Suppose you decide to invest this $5,000 per year in the same account earning 10% for 40 years rather than 20, how much will you have in the account after 40 years? (10 Points)12. Smith Company has the opportunity to invest in two projects. The cash flow for each project is as follows. (10 Points)YearCash Flow (A)Cash Flow (B)0 $ (50,000.00) $ (60,000.00)1 $ 17,000.00 $ 14,000.002 $ 22,000.00 $ 15,000.003 $ 16,000.00 $ 25,000.004 $ 10,000.00 $ 275,000.00Part 1: Assuming Smith Company has a 3 year payback cut off for investing in projects, based on the payback method, which project/projects should the company choose? Show your work on how you came up with the answer.Part 2: Utilizing a Net Present Value methodology, which project should Smith choose assuming a discount interest rate of 10%? Show your work on how you came up with the answer.Part 3: Utilizing an Internal Rate of Return methodology, which project should Smith Choose? Show your work on how you came up with the answer.Part 4: What is one pro and one con of each of the above methods? 13. You are considering investing in a company that cultivates stone for sale to landscaping companies. Use the following information: (10 Points)Sales price per ton of stone = $35Variable costs per tone= $6.95Fixed costs per year = $390,000Depreciation per year = $100,000Tax rate = 35%The discount rate for the company is 13%. The initial investment in equipment is $750,000 and the projects economic life is 10 years. Assume the equipment is depreciated on a straight line basis over the projects life.a.What is the accounting break-even level for the project?b.What is the financial break-even level for the project?

Get Help Today

Struggling with this particular assignment? Learn how our team of professional writers can help you today.

Leave a Reply

Your email address will not be published. Required fields are marked *