Please help fill out the attached excel example to answer instructions of problem 13-13! Instead of just whoing the correct answers, can you please include the formula you used to get the answers so I can learn how to do the work! Thank you!
Q: Imagine you are the project manager at an investment firm and given the task of preparing a report…
A: (Note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the…
Q: 6. A machine costs $30 000 to purchase and $12 000 per year to operate. The machine has a 10-year…
A: Solution Equivalent annual worth method is used to determine the equivalent annual cost that is…
Q: ote a price for a custom-designed doughnut machine to be delivered by the end of 2018. Once it is…
A: The minimum return on investment expected by the company is known as the required rate of return. It…
Q: Q1. Aling Azon bought 3 sets of air conditioning unit for her three bedrooms. She agreed to pay…
A: Down payment (D) = Php 5000 Monthly installment (M) = Php 3000 n = 1 year = 12 months r = 8% per…
Q: Please answer as thoroughly as possible. This is a huge refresher for me and I will use your…
A: In this question, we have to calculate the different ratios which are a liability to Equity ratio,…
Q: 2.3-2.4 (Excel): You have been offered a unique investment opportunity. If you invest $1 million at…
A: Net present value of investment is the difference between present value of inflows and outflows.…
Q: I need to see the work on this for it to make sense to me, can you show your work please? (The…
A: Monthly Payment = $900 Interest rate = 6% Loan term = 30 years Compounding time = 12 (12 times in a…
Q: A project manager does not understand the meaning of a term used by a team member in a technical…
A: comment feature: it is the feature which allow the user to write anything about the subject without…
Q: Analyze the change control process for the retail project's software configuration management. Your…
A: Any Development Project that retails merchandise, generally without transformation, and renders…
Q: I need the show your work version not excel answer. Please show your work. Thank you
A: Future value of a present amount With present value (PV), interest rate (r) and period (n), the…
Q: Students are required to provide a piece of writing (with a word limit of 400) on how the MYOB…
A: Computerized accounting includes using the computers and accounting software for recording, storing…
Q: Creative thinking is the ability to look at things differently, and find new ways of solving…
A: creative thinking means applying the intelligence and solving the problems and development of the…
Q: please display your formula used in your work
A: Monthly payment refers to the payment amount for the loan grounded on the constant payments as well…
Q: Depending on the way your practice works, you may need to give team members different access levels…
A: The three levels of access that can be granted to Team users of QuickBooks Online Accountant are…
Q: See below. I just need help with the red box with the 20,000 answer in it. It came back as…
A: As you have asked for help on the red box only so I'm explaining on that only. Please see Step 2 for…
Q: What is the IRR of the project?
A: IRR for an investment proposal is the discount rate that equates the present value of the expected…
Q: Q3. Ricardo plans to own a 1 hectare lot after 10 years for an estimated cost of P5M. To accumulate…
A: Time value of money: The time value of money is the idea that the value of money received today will…
Q: 4.A corporation is considering purchasing a machine that will save $210,000 per year before taxes.…
A: Net present value is the sum of all present values of cash inflows minus present value of cash…
Q: Consider the following dialogue between a systems professional, Joe Pugh, and a manager of a…
A: System Analysis Phase: System analysis is a course of action to gather the information related to…
Q: A well-reputed educational Institute has hired you as a project manager for development of their…
A: In project management cost estimation is the process of forecasting the financial and other…
Q: Identify the Given and the Unknown or what is being asked in the problem (b)Provide the formula to…
A: Deposits which are made by the depositor into the bank will earn an income on it which is known as…
Q: You will be given below some actual results to plug into the scorecard. You need to show…
A: Given: The values are given as, Financial (Return on Capital) - 18% Customer (Product Returns) = 805…
Q: 4. Thomas deposited 300,000Php now, so that his 3 year old daughter will receive 6 equal amounts…
A: The question is based on the concept of Annuities and Future Value in Financial Management.
Q: Match the two lists, below, by placing the capital letter from List 1 in each of the cells preceding…
A: Control Environment A control environment is made up of the standards, policies, procedures, and…
Q: 1. A Machine costs P80,000 and an estimated life of 10 years after 5 years using the following…
A: Answer to (A) Calculation of book value of asset after 5 years using straight line method: Original…
Q: e do IGNORE this if you already answered this problem, tutor) The requiremen
A: Note : As per the guidelines, only first three parts will be answered. Kindly post the remaining…
Q: 1. A Machine costs P80,000 and an estimated life of 10 years with a salvage value of P5,000. What is…
A: Business organizations are required to charge the depreciation expense on their assets so as the…
Q: What is the equations you use for the questions below to solve in excel?
A: The Gordon growth model: The Gordon Growth model recognizes that the dividends constitute income or…
Q: Below you will see three sets of inputs. After inputting all of your formulas, you should be able…
A: Cash budget refers to an estimation of cash inflows and outflows in a business over a specified…
Q: Please also do parts 4 and 5 while showing work so that way I can understand better. Thank you.
A: Solution 4: No, we would not recommend closing the North Store as there is net financial…
Q: Q3. IEdeas signed a contract to lease a building at P60,000 a year with an annual increase of P1,000…
A: Starting lease payment is P60,000 Annual increase in lease payment is P1,000 Worth of money is 8%…
Q: Can someone set up an excel sheet using the following data and show me the formula side, so I know…
A: Net Present value is sum of present value of cash flows. Present value of cash flow = Cash…
Q: spreadsheet solution
A: In business, strategic coming up with is important and needs valid info so as to form key choices.…
Q: Brew Bottle Company (BBC) is in the process of planning a more advanced computer-based information…
A: COSO Framework: Committee of sponsoring organization (COSO) was formed to achieve the objectives…
Q: (show manual working if possible, for me to understand. thank you.)
A: Here we will use the provided information to compute the cost of each component of capital. Once the…
Q: Q8: What is the value of a perpetuity of P100 per year if the discount rate is 5% and the cash flows…
A: The perpetuity value = $100 per year Discounting Rate = 5% First Perpetuity receivable: after 2…
Q: 2.You are considering an investment costing $300,000. If you want to recover the initial investment,…
A: Present Value of Ordinary Annuity refers to the concept which dictates the discounted value of a sum…
Q: Amy Pond, a fellow employee, wants to understand the basic steps in the recording process. Identify…
A: Recording process is a part of accounting process. In accounting all the transactions are identified…
Q: Imagine you are the project manager at an investment firm and given the task of preparing a report…
A: Note: Hi! Thank you for the question, As per the honor code, we are allowed to answer three…
Q: After finishing a project, how do you change the status of that project in QuickBooks Online…
A: After finishing a project, how do you change the status of that project in QuickBooks Online…
Q: are documents that help users learn their jobs and perform I consistently in those jobs.
A: Job descriptions define a person's role and accountability for his position in the company. It…
Q: Q2. Maria loaned an amount of 100,000Php payable in 15 equal quarterly instalments. The first…
A: The correct answer for the above mentioned is given in the following steps for you reference.
Q: Check your worksheet by changing the beginning work in process inventory to 100 units, the units…
A: Solution: Introduction: Process Costing is a determination of cost for each process. It is mainly…
Q: Please help on parts 4 and 5. Please also show work on how to do.
A: Solution 4: No, we would not recommend closing the North Store as there is net financial…
Q: PLease how to obtain YTM without excel and mathematical calculator. i really need to know how to…
A: Formula for YTM: YTM =C+(FV - PV)n(FV+PV)2 Where C= Coupon payment FV= Face value of security PV=…
Q: step by step
A: Honor code: Since you have posted a question with multiple sub-parts, we will solve the first three…
Q: I uploaded two pictures of the entire excel spreadsheet that I am trying to figure out. All the…
A:
Please help fill out the attached excel example to answer instructions of problem 13-13! Instead of just whoing the correct answers, can you please include the formula you used to get the answers so I can learn how to do the work! Thank you!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
- LONG-TERM FINANCING NEEDED At year-end 2019, total assets for Arrington Inc. were 1.8 million and accounts payable were 450,000. Sales, which in 2019 were 3.0 million, are expected to increase by 25% in 2020. Total assets and accounts payable are proportional to sales, and that relationship will be maintained; that is, they will grow at the same rate as sales. Arrington typically uses no current liabilities other than accounts payable. Common stock amounted to 500,000 in 2019, and retained earnings were 475,000. Arrington plans to sell new common stock in the amount of 130,000. The firms profit margin on sates is 5%; 35% of earnings will be retained. a. What were Arringtons total liabilities in 2019? b. How much new long-term debt financing will be needed in 2020? (Hint: AFN - New stock = New long-term debt.)Long-Term Financing Needed At year-end 2018, Wallace Landscapings total assets were 2.17 million, and its accounts payable were 560,000. Sales, which in 2018 were 3.5 million, are expected to increase by 35% in 2019. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to 625,000 in 2018, and retained earnings were 395,000. Wallace has arranged to sell 195,000 of new common stock in 2019 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2019. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on sales is 5%, and 45% of earnings will be paid out as dividends. a. What were Wallaces total long-term debt and total liabilities in 2018? b. How much new long-term debt financing will be needed in 2019? [Hint: AFN New stock = New long-term debt.)ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2019 Morrissey Technologies Inc.: Income Statement for December 31, 2019 Suppose that in 2020, sales increase by 10% over 2019 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2019 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would like to reduce its operating costs/sales ratio to 87.5% and increase its total liabilities-to-assets ratio to 30%. (It believes its liabilities-to-assets ratio currently is too low relative to the industry average.) The firm will raise 30% of the 2020 forecasted interest-bearing debt as notes payable, and it will issue long-term bonds for the remainder. The firm forecasts that its before-tax cost of debt (which includes both short- and long-term debt) is 12.5%. Assume that any common stock issuances or repurchases can be made at the firms current stock price of 45. a. Construct the forecasted financial statements assuming that these changes are made. What are the firms forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? b. If the profit margin remains at 6.25% and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In other words, what is the firms sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.)
- Future Values and Long-Term Investments Portman Corporation engaged in the following transactions during 2020: a. On January 1, 2020, Portman deposited $12,000 in a certificate of deposit paying 6% interest compounded semiannually (3% per 6-month period). The certificate will mature on December 31, 2023 b. On January 1, 2020, Portman established an account with Lee County Bank. Portman will make quarterly payments of $2,500 to Lee beginning on March 31, 2020, and ending on December 31, 2021. Lee guarantees an interest rate of 8% compounded quarterly (2% per 3-month period). Required: 1. Prepare the cash flow diagram for each of these two investments. 2. Calculate the amount to which each of these investments will accumulate at maturity. (Note: Round answers to two decimal places.)Begin with the partial model in the file Ch02 P21 Build a Model.xlsx on the textbooks Web site. a. Using the financial statements shown here for Lan Chen Technologies, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 2020. The federal-plus-state tax rate is 25%. b. Assume there were 15 million shares outstanding at the end of 2019, the year-end closing stock price was 65 per share, and the after-tax cost of capital was 10%. Calculate EVA and MVA for 2020. Lan Chen Technologies: Income Statements for Year Ending December 31 (Millions of Dollars) Lan Chen Technologies: December 31 Balance Sheets (Thousands of Dollars)Investment Discount Amortization Schedule On January 1, 2019, Rodgers Company purchased 200,000 face value, 10%, 3-year bonds for 190,165.35, a price that yields a 12% effective annual interest rate. The bonds pay interest semiannually on June 30 and December 31. Required: 1. Record the purchase of the bonds. 2. Prepare an investment interest income and discount amortization schedule using the effective interest method. 3. Record the receipts of interest on June 30, 2019, and June 30, 2021.
- Investment Premium Amortization Schedule On January 1, 2019, Lynch Company acquired 13% bonds with a face value of 50,000. The bonds pay interest on June 30 and December 31 and mature on December 31, 2021. Lynch paid 51,229.35, a price that yields a 12% effective annual interest rate. Required: 1. Record the purchase of the bonds. 2. Prepare an investment interest income and premium amortization schedule using the effective interest method. 3. Record the receipts of interest on June 30, 2019, and December 31, 2021.Leverage Cook Corporation issued financial statements at December 31, 2019, that include the following information: Balance sheet at December 31,2019 Assets $8,000,000 Liabilities $1,200,000 Stockholders' equity (300,000 shares) $6,800,000 Income statement for 2019: Income from operations $1,200,000 Less: Interest expense (100,000) Income before taxes $1,100,000 Less: Income taxes expense (0,30) (330,000) Net income $ 770,000 The levels of assets, liabilities, stockholders' equity, and operating income have been stable in recent years; however, Cook Corporation is planning a 51,800,000 expansion program that will increase income from operations by $350,000 to $1,550,000, Cook is planning to sell 8.5% notes at par to finance the expansion. Required: What earnings per share does Cook report before the expansion?Long-Term Financing Needed At year-end 2019, Wallace Landscaping’s total assets were $1.59 million, and its accounts payable were $380,000. Sales, which in 2019 were $2.5 million, are expected to increase by 20% in 2020. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current liabilities other than accounts payable. Common stock amounted to $570,000 in 2019, and retained earnings were $350,000. Wallace has arranged to sell $180,000 of new common stock in 2020 to meet some of its financing needs. The remainder of its financing needs will be met by issuing new long-term debt at the end of 2020. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Its net profit margin on sales is 3%, and 60% of earnings will be paid out as dividends. What was Wallace's total long-term debt in 2019? Do not round intermediate calculations. Enter your answer in…
- Review of Forecast Assumptions. Dodd Manufacturing Corporation has engaged you to attest to the reasonableness of the assumptions underlying its forecast of revenues, costs, and net income for the next calendar year, 2018. Four of the assumptions follow.1. The company intends to sell certain real estate and other facilities held by Division B at an after-tax profit of $600,000; the proceeds of this sale will be used to retire outstanding debt.2. The company will call and retire all outstanding 9 percent subordinated debentures (callable at 108). The debentures are expected to require the full call premium given present market interest rates of 8 percent on similar debt. A rise in market interest rates to 9 percent would reduce the loss on bond retirement from the projected $200,000 to $190,000.3. Current labor contracts expire on September 1, 2018, and the new contract is expected to result in a wage increase of 5.5 percent. Given the forecasted levels of production and sales,…For the year ended 2020, Frilo Company has $1,250,000 of debt with an annual interest rate of 8.8%, $2,000,000 of preferred stock with an annual preferred dividend rate of 10.5%, $3,500,000 of common stock (total book value), and 250,000 common shares outstanding. In 2021, the company plans to raise $500,000 external capital to fund a new project through a term loan with an interest rate of 9.3%. The new loan's sinking fund provision requires the loan to be fully amortized over the next 5 years, commencing in 2022. The company expects that the existing debt and preferred stock will not be retired until the year 2026; hence, they will remain in the same amount in 2021. If the project goes as planned, the company expects $1,200,000 of EBIT in 2021. The company's tax rate is 40%. What will the expected earnings per share under the new debt alternative be? (Hint: Perform EBIT-EPS Analysis in the long-term financing decisions.) Group of answer choices $1.58 $1.66 $1.55 $1.51…