Income Statement: A small food stall owned by Ms. Lopez is located at San Fernando Pampanga. She earns P 285,000 at the present and is expected to increase by 10% yearly. Prepare her 5-year income statement. Financial Assumptions: 1. 10% of the projected sales is cost of sales 2. The operating expenses is amounting to 35,000 for year 2018 and it's expected to increase by 5% per year. 3. Income tax is assumed to be 20%. 2018 2019 2020 2021 2022 Sales Less: Cost of Sales Gross Profit Less: Operating Expenses Net income before tax Less: Income tax Net revenue after tax

Income Statement: A small food stall owned by Ms. Lopez is located at San Fernando Pampanga. She earns P 285,000 at the present and is expected to increase by 10% yearly. Prepare her 5-year income statement. Financial Assumptions: 1. 10% of the projected sales is cost of sales 2. The operating expenses is amounting to 35,000 for year 2018 and it's expected to increase by 5% per year. 3. Income tax is assumed to be 20%. 2018 2019 2020 2021 2022 Sales Less: Cost of Sales Gross Profit Less: Operating Expenses Net income before tax Less: Income tax Net revenue after tax

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 20P

See similar textbooks

Similar questions

Ms Moore owns a 16 unit apartment complex. The market rent on each unit is $500 per month. It is expected that on average, one unit will be vacant for the 3 months a year. The annual operating expenses that on average, one unit will be vacant for the 3 months each year. The annual operating expenses are estimated to be 39 percent of EGI. The annual debt service payments are estimated to be 39 percent of EGI. The annual debt service payments are estimated to be $45,000. If the overall cap rate is assumed to be 9.25%, what is the estimated value of the property? a. 603,405 b. 613,287 c. 623,189 d. 633,081 please solve without excel.
Assume that a customer shops at a local grocery store spending an average of $350 a week, resulting in a retailer profit of $30 each week from this customer. Assuming the shopper visits the store all 52 weeks of the year, calculate the customer lifetime value if this shopper remains loyal over a 10-year life span. Also, assume a 6 percent annual interest rate and no initial cost to acquire the customer. How much does the customer yield per year in profits for this retailer? (Round to the nearest dollar.)
Question: : Lillian is considering using some of the cash generated from her mail-order business to open a retail store. The fixed investment in the store is expected to be $3.5 million. This investment can be depreciated straight line over five years. Variable costs are estimated to be 35% of sales. The tax rate is 0%. Cash fixed costs total $600,000 per year. a) What is the net income breakeven point (in sales $) during the first five years? What is it after the fifth year?
Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no cost (i.e. you will pay your bills on a two month lag). Your monthly expenses for rent, wages, utilities, and so forth will be approximately $3,500 per month. You have deposited $15,000 in a checking account to begin your operations and would like to maintain a minimum balance of $5,000 in that account. 1. Explain the purpose of creating budgets and how your budget will help the business remain capitalized 2 . Will you need additional funds at some point? Justify your answer. 3. How would you raise capital in the future?
Hello can you please walk me through how to do this the annual income is 113,300 It is wise to set aside 7.5% of gross monthly income for 401 k investment. Assume the investment earns a 5% annual return and use Excel to determine the balance after 40 years for the unskilled worker and for your expected income. Then use Excel to determine how many years it would take for the unskilled worker and for your expected investment to reach $500,000.
Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000, and the remainder is financed at (15) percent compounded semi-annually with semi-annual payments over 4 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows a) Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period. b) Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period. c) Plan 3: Make equal end-of-period payments. d) Plan 4: Make a single payment of principal and interest at the end of the loan period. e) A different plan: Pay off the principal in such a way that it is X, 1.5X, 2X, 2.5X... till the end of the last payment period. In addition, pay the accumulated interest at the end of each interest period.
Windsor Tool Inc. has a $500,000 loan for a new EDM machine to be used in the tool/die production. The interest rate for this loan is 6% compounded annually. The finance manager decides that the company will make $40,000 payment each year, starting the end of the first year. By calculation, it will take the company N years to pay back the loan. Notice that the payments for Year1 to Year(N-1) will be $40,000 as planned. The last payment at the end of Year-N will be smaller than $40,000. First, calculate the value for N=? (years) Second, calculate the last payment for Year(N)=? Notice that this is a Multi-Answer question, you have to pick one for the number of years and pick one for the last payment amount. N=22 Years N=24 Years N=26 Years N=28 Years Payment for last Year = $31,905. Payment for last Year = $16,794. Payment for last Year = $10,540. Payment for last Year = $36,555.
Carla Vista Design has daily sales of $54,000. The financial management team has determined that a lockbox would reduce the collection time by 1.7 days. Assuming the company can earn 4.1 percent interest per year, what are the savings from the lockbox? (Round answer to 2 decimal places, e.g. 12.25.) what is the Savings from the lockbox per year?
Phillip Morrisexpects the sales for his clothing companu to be $550,000 next year. Philip notes the net assets (Assets - Liabilities) will remain unchanged. His clothing firm will enjoy a 12% return on total sales. He will start the year with $150,000 in the bank. What will Philip's ending cash balance be?
French Fried Food Inc. wishes to accumulate P500,000 during the next 24 months to open a second location. What constant amount should it pay at the end of each month into a money market savings account with an investment dealer, to attain its saving objectives? The planning assumption is that the account will earn 10% compounded semi-annually. Find the present value of an annuity which pays P1,460 at the end of every 3 months of 6 years, if money is worth 9% compounded monthly? If P2,000 is invested at the end of every year at 8% compounded semi-annually, what will be the total value of the periodic investment after 20 years?
Salem Co. has a year-end of December 31 and they are evaluating the cash flows of some potential investments/projects they are considering for their next fiscal year, starting January 1. Salem Co. rents some of their equipment out to other companies for extra cash flow. They are evaluating three different options to structure their rental agreement in order to earn the largest amount of payments as possible. If Salem receives the rental payments of $15,000 for the next five years on each January 1 instead, at 7% compounded annually, how much is that worth today? $61,502.96 is incorrect
Your company will generate GH¢ 55,000 in annual revenue each year for the next eight years from a new information database. The computer system needed to set up the database costs GH¢ 250,000. If you can borrow the money to buy the computer system at 7.5 percent annual interest, can you afford the new system? First National Bank charges 7.5 percent compounded quarterly on its business loans. First United Bank charges 7.5 percent compounded semi-annually. As a potential borrower, which bank would you go to for a new loan?