Final Project Milestone 2

Can you help me with this one?

Can someone please help me solve this question using Excel?

Solve the problem

Data Section - PROVIDED BY THE CLIENT Unit Sales Sales are expected to increase by 5% every month. The total sales for the Fiscal Year 2022 is 15% higher than the total sales for 2021. April May 15,000 10,000 June 16,000 July August September 14,000 15,000 Fixed Assets Cost 12,000 Land 150,000.00 Building 205,000.00 10 year depreciation, bought on May 31, 2021, Work Ethics Gen. Mdse uses the Declining Balance Method collections from customers: Office Equipment 100,000.00 20% are acquired on May 31, 2021 Cash $8.000 20% are acquired on August 31, 2021 Accounts receivable 107,800 20% are acquired on October 31, 2021 Merchandise inventory 52,800 20% are acquired on December 31, 2021 530,000 $698,600 Fixed assets (net) 20% are acquired on March 31, 2021 Total assets Use the Straight Line Method (5 years) Machinery 75.000.00 5 year Accounts payable (merchandise) Loans Payable Owner's equity Total liabilities & equity $74,800 $400,000 5 year loan, 12% interest taken out on May 31, 2021, paid…

Compute internal rate of return (IRR), payback period, and profitability index (PI) for each project.

Please give me answer

Answer

The projects review committee of Microsoft has $20 million to allocate next year to new software product development. Any or all of five projects in the table below may be accepted. All amounts are in $1000 units. Each project has an expected life of 7 years. Select the project(s) if a 13% return is expected.

H1. Account

Early in 2024, the Excalibur Company began developing a new software package to be marketed. The project was completed in December 2024 at a cost of $15 million. Of this amount, $11 million was spent before technological feasibility was established. Excalibur expects a useful life of five years for the new product with total revenues of $20 million. During 2025, revenue of $6 million was recognized. Required: Prepare a journal entry to record the 2024 development costs.

Using a spreadsheet  answer the following problem

10. Answer all FIVE of the the following required questions!

help me solve this in excel please!!! show all steps/screenshot excel please will give thumbs up ASAP

A28

A6

Current Attempt in Progress Sandhill Corp. management is planning to convert an existing warehouse into a new plant that will increase its production capacity by 45 percent. The cost of this project will be $9,965,338. It will result in additional cash flows of $2,080,200 for the next eight years. The discount rate is 13.19 percent. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) a. What is the payback period? (Round answer to 2 decimal places, e.g. 15.25) The project's payback period is years b. What is the NPV for this project? (Round intermediate calculations and final answers to 0 decimal places, e.g. 1,251. Do not round…

ezto.mheducation.com/ext/map/index.html?_con%3Dcon&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghm Assume the following (1) contribution margin = $150,0000 (2) net operating income $15,000, and (3) sales increase by 14%. Given these three assumptions, net operating income will increase by: Multiple Choice 15 1%. 14%. 116. 140%. < Prev 15 of 50 Next 2 Search for anything

ICE (Week 12, Lesson 123 Winter 2024 HRMNTO1-4 Launa Vaughan A. MODERNIZATION CASE (10 Marks) Management is contemplating investing $1.5 million to modernize a plant and they would like to get a 20% internal rate of return. Should they go ahead with the decision? The economic life of the project is estimated at 10 years. The savings (or cash inflows) are estimated at $300,000 per year. The cost of capital is 14%. Required:Calculate the Net Present Value of the project? (2 marks) What is the approximate IRR of the project? (2 marks) What is the payback of the project? (1 mark)Should management go ahead with the project? Why or why not? (2 marks) What factors, if they changed, would impact your decision? (3 marks)

On September 30, 2021, Athens Software began developing a software program to shield personal computers from malware and spyware. Technological feasibility was established on February 28, 2022, and the program was available for release on April 30, 2022. Development costs were incurred as follows: September 30 through December 31, 2021 January 1 through February 28, 2022 March 1 through April 30, 2022 Athens expects a useful life of five years for the software and total revenues of $6,500,000 during that time. During 2022, revenue of $1,170,000 was recognized. Required: Prepare a journal entry in each year to record development costs for 2021 and 2022. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet < 1 2 Record the development costs for 2021. Note: Enter debits before credits. Date 2021 $2,280,000 880,000 480,000 General Journal Debit Credit

Please provide clear explanation with step by step guidiance. QN 1 & 2