a leading firm in the sports​ industry, produces basketballs for the consumer market. For the year ended December​ 31,

2017​,

Verena

sold

242,100

basketballs at an average selling price of

$41

per unit. The following information also relates to

2017

​(assume constant unit costs and no variances of any​ kind):

Inventory, January 1, 2017:

29,300 basketballs

Inventory, December 31, 2017:

27,200 basketballs

Fixed manufacturing costs:

$1,200,000

Fixed administrative costs:

$3,234,000

Direct materials costs:

$12 per basketball

Direct labor costs:

$9 per basketball

The Goal Is to be able to withdraw $60,000 a year. From 65 to age 85

1. YOUR ESTIMATE/BEST GUESS: I intend to withdraw $_________________ at the END of each year from my retirement account to support my lifestyle. Input how much you think you need to live comfortably in your retirement years. To help you with your estimate, experts estimate you should plan to have approximately 70% of your ending salary in your retirement years in order to maintain your standard of living. (Assume no pension or Social Security benefits.)

When I retire, my goal is to have saved $_______________________ in a retirement account. I believe these funds will be sufficient to maintain my desired lifestyle through my retirement years. Input this figure BEFORE you calculate anything on the Excel template. Just take a guess. What do you think is a reasonable amount to have as your nest egg on the day you retire (age 65 in this example) that would support the annuity withdrawal from the previous question.

Based on my total retirement savings from question #5, assuming those funds are invested at 5% compounded annually, I am able to withdraw $______________ from my retirement fund each year over the next 20 years. (Show all inputs below.) Compute with the financial calculator (solve for PMT).

INPUTS:             N =

I/Y =

FV =

PV =

PMT =

In order to meet your retirement goals (withdrawing an annuity stream for 20 years) from question #4, how much would you need to have in your retirement account at age 65? In other words, based on the amount of the annuity from question #4, the total retirement savings account must have an actual balance of $______________ in the account on the day of retirement at age 65 assuming a rate of 5% compounded anually. This is a present value of annuity calculation (CPT PV). (Show all inputs below.)

INPUTS:             N =

I/Y =

FV =

PV =

PMT =

Review your answers from questions #4-#7. This is just the “off the cuff” approach to retirement planning. How close were you to “reality”? What are your thoughts or conclusions?

____________________________________________________________________________________

____________________________________________________________________________________

Now let’s take a more analytical approach to retirement planning:

INPUT INTO TEMPLATE:

I hope to have $___________________ of retirement savings in the bank by age 30.

I hope to earn $___________________ per year when I’m 30.

I hope to earn $___________________ per year when I’m 40.

I hope to earn $___________________ per year when I’m 50.

I hope to earn $___________________ per year when I’m 60.

If my life expectancy is age 85, my retirement years will total ________.

SHOW WORK IN THE TEMPLATE: Assume I invest 15% of my salary annually based upon the above salaries at a savings rate of 6.5% compounded annually. At retirement age, my nest egg (including the retirement funds I had saved by age 30) would total:

$_______________________   (from Excel template)

The compounding frequency on a loan is once every year. If you borrow $35,974.44 at an annual interest rate of 3.75%, how much must you pay every year so that you pay back the loan in 17 years? How do I do the steps in Excel? using PEMDAS

Please show steps

IF YOU GOT 2900. HOW DID YOU GET THAT ?

The Haverly Company expects to finish the current year with the following financial results, and is developing its annual plan for next year.

The following facts are available.

• Payables are almost entirely due to inventory purchases and can be estimated through COGS, which is approximately 45% purchased material.
• Currently owned assets will depreciate an additional $1103000 next year.
• There are two balance sheet accruals. The first is for unpaid wages. The current payroll of $31 million is expected to grow by 13% next year. The closing date of the year will be six working days after a payday. The second accrual is an estimate of the cost of purchased items that have arrived in inventory, but for which vendor invoices have not yet been received. This materials accrual is generally about 8% of the payables balance at year end.
• The combined state and federal income tax rate is 42%.
• Interest on current and future borrowing will be at a rate of 10%.

PLANNING ASSUMPTIONS

Income Statement Items

1. Revenue will grow by 12% with no change in product mix. Competitive pressure, however, is expected to force some reductions in pricing.
2. The pressure on prices will result in a 1.5% deterioration (increase) in the next year's cost ratio.
3. Spending in the marketing department is considered excessive and will be held to 20% of revenue next year.
4. Because of a major development project, expenses in the engineering department will increase by 20%.
5. Finance and administration expenses will increase by 7%.

Assets and Liabilities

6. An enhanced cash management system will reduce cash balances by 10%.
7. The ACP will be reduced by 15 days. (Calculate the current value to arrive at the target.)
8. The inventory turnover ratio (COGS/inventory) will decrease by 0.5x.
9. Capital spending is expected to be $5 million. The average depreciation life of the assets to be acquired is five years. The firm uses straight-line depreciation, and takes a half year in the first year.
10. Bills are currently paid in 50 days. Plans are to shorten that to 30 days.
11. A dividend totaling $1.5 million will be paid next year. No new stock will be sold.

Develop next year's financial plan for Haverly on the basis of these assumptions and last year's financial statements. Include a projected income statement, balance sheet and a statement of cash flows. Enter your dollar answers in thousands. For example, an answer of $200 thousands should be entered as 200, not 200000. Round dollar answers and intermediate calculations to the nearest thousand. Round the percentage values to 1 decimal place. Enter all amounts in Income Statement as a positive numbers. Use a minus sign, to indicate a negative cash outflow, or a decrease in cash in Balance Sheet and Cash Flow Statement.

"You purchased an airplane for $450,000 and will depreciate it using a 7-year MACRS with a 5-year life. Salvage value in year 5 is expected to be $176,000. The airplane is expected to increase revenues by $144,000 per year. However, O&M costs are expected to be $29,000 per year. Your company is in the 21% tax bracket and your MARR is 18%. What is the Net Present Worth of this investment?"

"You purchased an airplane for $494,000 and will depreciate it using a 7-year MACRS with a 5-year life. Salvage value in year 5 is expected to be $188,000. The airplane is expected to increase revenues by $193,000 per year. However, O&M costs are expected to be $29,000 per year. Your company is in the 21% tax bracket and your MARR is 20%. What is the Net Present Worth of this investment?"

1. Use the information below to answer the next 3 questions:

   At the beginning of the year, JJB Inc. estimated that overhead would be $880,000 and direct labor hours would be 220,000 hours. At the end of the year actual overhead was $920,600 and there were actual direct labor hours of 230,000. Year ended unadjusted COGS is $2,000,000.

   What is the Rredetermined Overhead Rate?

   		$2.63
   		$4
   		$4.18
   		None of the above

QUESTION 8

1. What is the overhead variance?

   		$200 overapplied
   		$400 underapplied
   		$600 overapplied
   		$600 underapplied

QUESTION 9

1. The adjusted Cost of Goods Sold is:

   		$2,000,000
   		$2,000,400
   		$2,000,600
   		$1,999,400

     In the first year of operations in 2017, the pretax accounting income of Lisle Company was$16,000. Included in pretax accounting income were the following:

     (2) $33,000 of sales revenue that will not be recognized for tax purposes until it is collected;

(3) $32,000 in warranty expense that was recognized as product sales were made according to GAAP, but will be deductible for tax purposes only when the actual disbursements are made; and.

(1) $4,000 expense for a premium for life insurance covering the firm’s president, with Lisle named as beneficiary, which is not deductible for tax purposes.

     The temporary differences are expected to reverse in the following pattern:

                                                     Installment                         Warranty

                                 Year            Collections                        Payments

                               2017                   8,300                            18,200

                               2018                 12,800                            10,300

                                2019                 11,900                              3,500

                                                      $33,000                          $32,000

     In addition, Lisle records $12,000 more depreciation for tax purposes than for accounting financial statements, and it is not expected to start reversing in the near future.

     The enacted tax rate for 2017 is 35%; in 2017, due to a significant change in the tax law, the enacted tax rate for corporations became 21% for 2018 and future years.

     Required:

1. Calculate taxable income for 2017, and prepare the journal entry necessary to record income taxes at the end of 2017. How would any deferred tax amounts be reported on a classified balance sheet? Show how taxable income, income tax expense, and net income would be reported on the income statement.

2. Assume that 2018 pretax accounting income is $8,000, the insurance premium is the same as for 2017, and Lisle records an additional $12,000 more depreciation expense for tax purposes than for accounting financial statements. The portions of previous differences expected to reverse in 2018 do reverse exactly as estimated. Prepare the journal entry necessary to record income taxes at the end of 2018. How would any deferred tax amounts be reported on the 2018 balance sheet? Show how taxable income, income tax expense, and net income would be reported on the 2018 income statement.

python.Write a python program that prompts the user to enter the year and first day of the year, and displays the first day of each month in the year. For example, if the user entered the year 2020 and 3 for Wednesday, January 1, 2020, your program should display the following output:

January 1, 2020 is Wednesday

February 1, 2020 is Saturday ……

December 1, 2020 is Tuesday

In the year 2015, leaders from 193 countries of the world gathered and moderated by the United Nation and finally summarized that there are 17 goals for the world to be achieved in 2030 named as UNDP Sustainable Development Goals (SDG) towards 2030.

1. Explains 5 (five) of the goals with the examples that important to be in line with engineering profession which you can contribute in your career after graduation.

THIS IS THE LINK FOR 17 GOAL.

https://www.undp.org/content/dam/undp/library/corporate/brochure/SDGs_Booklet_Web_En.pdf