PLEASE SHOW STEPS IN EXCEL SHEET

MC algo 26-19 Cash Disbursements Weisbro and Sons purchases its inventory one quarter prior to the quarter of sale. The purchase price is 60 percent of the sales price. The accounts payable period is 60 days. The accounts payable balance at the beginning of Quarter 1 is $25,800. What is the amount of the expected disbursements for Quarter 2 given the following expected quarterly sales?

Quarter 1: $ 67,000 Quarter 2: $ 108,000 Quarter 3: $ 100,000 Quarter 4: $ 109,000

Multiple Choice

A. $40,200

B. $61,600

C. $65,000

D. $63,200

E. $57,000

. What is the present value of the following set of cash​ flows, discounted at

10.8 %10.8%

per​ year?

b. What is the present value of the following set of cash​ flows, discounted at

10.8 %10.8%

per​ year?

c. Each set contains the same cash flows

​($ 12$12​,

$ 22$22​,

$ 32$32​,

$ 42$42​,

$ 52$52​),

so why is the present value​ different?

a. What is the present value of the following set of cash​ flows, discounted at

10.8 %10.8%

per​ year?

The present value of the cash flow stream is

​$nothing.

​(Round to the nearest​ cent.)b. What is the present value of the following set of cash​ flows, discounted at

10.8 %10.8%

per​ year?

The present value of the cash flow stream is

nothing.

​(Round to the nearest​ cent.)c. Each set contains the same cash flows

​($ 12$12​,

$ 22$22​,

$ 32$32​,

$ 42$42​,

$ 52$52​),

so why is the present value​ different?  ​(Select the best choice​ below.)

A.The present value in part

​(b​)

is higher because the larger cash flows occur sooner.

B.The present value in part

​(a​)

is higher because the larger cash flows occur sooner.

C.The present value in part

​(b​)

is lower because the larger cash flows occur sooner.

D.The present value in part

​(a​)

is lower because the larger cash flows occur sooner.

You need to save a total of $7,500 in order to buy a new motorcycle. You are starting with savings of $4,000 but will make no additional contributions. The annual interest rate is 5%. In excel compute how long you would need to wait in order to reach your goal for interest that is compounded annually, semi-annually, quarterly, monthly, weekly, and daily. Which of the following accurately depicts this calculation?

Which of the following statements is CORRECT? Group of answer choices 1) The use of debt financing will tend to lower the basic earning power ratio, other things held constant. 2) A firm that employs financial leverage will have a higher equity multiplier than an otherwise identical firm that has no debt in its capital structure. 3) If two firms have identical sales, interest rates paid, operating costs, and assets, but differ in the way they are financed, the firm with less debt will generally have the higher expected ROE. 4) The numerator used in the TIE ratio is earnings before taxes (EBT). EBT is used because interest is paid with post-tax dollars, so the firm's ability to pay current interest is affected by taxes. 5) Other things held constant, increasing the total debt to total capital ratio will increase the ROA.

Your company is considering investing in a new project and wants to know the discounted payback period. The initial investment in the project is​ $12,000 and the expected annual profit is​ $2,800 per year. You also expect to have to have to overhaul the equipment every 4​ years, which will cost​ $600 (that​ is, in years​ 4, 8,​ 12, etc. The project will also make the​ $2,800 profit in those​ years). Given an interest rate of​ 8%, what is the discounted payback​ period?

1. Martin Oil and Gas Inc was formed right after the 2012 presidential elections. The company did not fare well for the five years, but finally turned around in the sixth year of operations. Rocco’s operating income (EBIT) for its first six years of operations is reported below.
   

   Year	EBIT
   2013	-$300,000
   2014	-$250,000
   2015	-$200,000
   2016	-$150,000
   2017	-$100,000
   2018	$1,500,000

   
     
   The company follows a very conservative approach and hence does not carry any debt in its book, hence its operating income equals earnings before taxes. The corporate tax rate has remained constant at 30%. Assume that the company took full advantage of the carry-back, and carry-forward provisions in the Tax Code, and assume that the current provisions were applicable in 2013 through 2018. How much tax did the company pay in 2018?

   	a	$200,000
   	b	$175,000
   	c	$375,000
   	d	$150,000
   	e	$450,000

A security will make payments of $25 per month, plus $1000 at maturity. The price of this security is $2000. Which of the following is true? If the time to maturity is 7 years then the effective rate is 10.52%% If the time to maturity is 4 years then the effective rate is 10.52% If the time to maturity is 7 years then the effective rate is 10.05% If the time to maturity is 4 years then the yield to maturity is 10.05% If the time to maturity is 7 years then the effective rate is 3.34%

Provide Sue with financial advice on which option has the potential to yield the highest monetary value. Support your rational with calculations using time value of money and comment on the risk return relationship for each option, assume interest rate on savings is 4% and is compounded semi-annually.

Sue James is a 55-year old accountant who works at Ernst and Young (EY) who is about to retire. She has the following decision to make:

Option A – Select a lump sum gratuity payment of $120,000 with a reduced pension of $1,750 per month.

Option B – Select a monthly pension of $3,300 with no lump sum gratuity payment.

In addition, Sue has a loan of $72,000 with loan payments of $1,200 per month for the next five years.

Tony Inc began operating in 2015. The company lost money the first year but has been profitable ever since. The company’s taxable income (EBT) for its first five years is listed below. Each year the company’s corporate tax rate has been 35 percent. Year Taxable Income 2015 -$4 million 2016 1 million 2017 2 million 2018 3 million 2019 5 million Assume that the company has taken full advantage of the Tax Code’s carry-back, carry-forward provisions and that the current provisions were applicable during these years. How much did the company pay in taxes in 2018 and 2019 respectively?

a)$0, $1,750,000

b)$700,000, $1,750,000

c)$800,000, $1,750,000

d)$600,000, $700,000

e)$300,000, $800,000

What is the difference in PVs between a 6-year annuity due of $1000 and a 5-year annuity due of $1000 if r=6%? solve using finance

Question 1: All of the following are types of change that clients may experience and where the financial planner can help them to effectively adapt. 1. Environmental Change. 2. Volitional Change. 3. Climate Change. 4. Life-Cycle Change. Select one: a. 1 and 3 b. 2 and 4 c. 3 only d. 1, 2, and 4

Question 2: Which of the following Financial Planning Strategy Mode(s) is / are the most important in terms of fostering Client Trust and Relationship Commitment?

1. Planner-Driven Mode.

2. Data-Driven Mode.

3. Policy-Driven Mode.

4. Relationship-Driven Mode.

5. Client-Driven Mode.

Select one:

a. 4 only

b. 1 and 4

c. 2 and 4

d. 2, 3, and 4

Question 3: All of the following are elements of "choice architecture," per Thaler and Sunstein, EXCEPT:

1. Incentives

2. Understand Mapping

3. Motivate Change

4. Defaults

5. Give Feedback

6. Expect Error

7. Structure Complex Choices

Select one:

a. 6

b. 4 and 6

c. 3

d. 1 and 3

Question 4: What are the characteristics of a good financial planning policy?

Select one:

a. It must always have two parts.

b. It should should change as external circumstances change and it should be open to interpretation.

c. It should be broad enough to encompass any external change while also being specific enough to always return an unambiguous answer.

d. It should be narrow enough to apply to very specific external circumstances while also being broad enough for planner interpretation.

Consider the following expansion capital budgeting problem.

A capital budgeting decision is being considered that would involve an expansion and simultaneous replacement of old equipment. The project is expected to have a 6 year life for the firm.

This project will replace some existing equipment which currently has a book value (BV) of $200k and an estimated market salvage value of $375k. The new project will require new equipment costing $2000k, which will be depreciated straight-line to a book value of $200k at the end of 6 years. Due to new energy efficient technology, replacing the old equipment with the new more efficient equipment will generate an immediate tax credit of 5% of the equipment’s cost. The expansion will require an additional investment in NWC of $200k.

Sales are expected to increase by $1000k the first year and grow by 15% in years 2 and 3, then by 5% annually during the remaining 6 year life. Cost of goods sold is forecasted to be 45% of the increased sales, and other selling and general administrative expenses are forecasted to be 10% of the increased sales.

It is forecasted that the new equipment will have a salvage value of $300k at the end of the project’s 6 year life.

The firm’s weighted average cost of capital (WACC) for projects of this risk level is 8%. The firm’s marginal tax rate is T = 40%.

Use the Excel template to complete the capital budgeting analysis. Your Excel analysis should clearly indicate the cash flow analysis timeline and should provide the project’s NPV, IRR, PBP, PI, and also illustrate the project’s NPV Profile.

___

Can you please help to fill out the arrays on the right of the following google sheet

https://docs.google.com/spreadsheets/d/1Z2pFSPrg99XXZE0wSj6k89AmloH8mkgLWzvNwaawFPs/edit?usp=sharing

Understanding financial statements are key to the success of any organization. How do financial statements relate to the mission statement of an organization? Explain how they aid in the mission of the organization.

What is the current year's return on assets (ROA)?

Submit

Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))