New Perspectives Excel 2019 | Module 7: SAM Project 1a

Valerian State College SUMMARIZING YOUR DATA WITH PIVOTTABLES      GETTING STARTED Open the file NP_EX19_7a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_7a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_7a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.   PROJECT STEPS Lael Masterson works in the Student Activities Office at Valerian State College in…

Details

New Perspectives Excel 2019 | Module 6: SAM Project 1a

Oval Lake Hospital MANAGING YOUR DATA WITH DATA TOOLS      GETTING STARTED Open the file NP_EX19_6a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_6a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_6a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.   PROJECT STEPS Donnie Cruz is a finance assistant for Oval Lake Hospital in south…

Details

New Perspectives Excel 2019 | Modules 1-4: SAM Capstone Project 1a

Tallridge Regional Medical Center Formatting, Formulas, and Charts      GETTING STARTED Open the file NP_EX19_CS1-4a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_CS1-4a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX19_CS1-4a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building…

Details

New Perspectives Excel 2019 | Module 5: SAM Project 1a

Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS      GETTING STARTED Open the file NP_EX19_5a_FirstLastNamexlsx, available for download from the SAM website. Save the file as NP_EX19_5a_FirstLastNamexlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer: xlsx docx With the file NP_EX19_5a_FirstLastNamexlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file…

Details

The business is a Home Furniture Retailer which buys from suppliers

Using MYOB Accounting program to record the same business transactions and end of month adjusting entries and generate the required reports from MYOB.   Business data The business is a Home Furniture Retailer which buys from suppliers and sells to other retail businesses.  The business name is “Student Name Furniture Pty Ltd” (students are to insert their name) and is located at Your Address – Sydney NSW 2000. The business’ sales are both over-the-counter cash and credit to wellknown customers.   Company Name Address ABN Current Financial Year Starter Chart “Your name” Furniture Pty Ltd Your Address Your student Number 2023 Wholesale Furniture store   Financial Year                              1st July 2022 – 30th June 2023   Transaction Sources: Cash registers –…

Details

QUT and All Star Manufacturing

Project 1 Calculations must be done in Excel – This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV).   QUT corporation projects their future unit sales for a new headphone. The projected unit sales are as below.   1 2 3 4 5 Unit sales 75000 88000 120000 95000 60000   To produce the headphones, the initial net working capital of $2,000,000 is required and additional net working capital is also required each year, which is 20% of the projected sales increase for the following year. The net working capital will be recovered at the end of a project. In addition, the initial installation cost of the machine for…

Details

Emily Dao, 27, just received a promotion

Emily Dao, 27, just received a promotion at work that increased her annual salary to $37,000. She is eligible to participate in her employer’s 401(k) retirement plan in which the employer matches, dollar for dollar, workers’ contributions up to 5 percent of salary. However, Emily wants to buy a new $25,000 car in three years, and she wants to have enough money to make a $7,000 down payment on the car and finance the balance. Fortunately, she expects a sizable bonus this year that she hopes will cover that down payment in three years. A wedding is also in her plans. Emily and her boyfriend, Paul, have set a wedding date two years in the future, after he finishes medical school.…

Details

Morning Star and Aileen Ltd

Question 1 Morning Star Ltd was registered on 1 July 2021, as a company with a constitution limiting the shares that could be offered to 5 000 000 Ordinary shares (including all classes) and 2 000 000 preference shares. The company issued a prospectus dated 1 July 2021 inviting the public to apply for 2 000 000 Ordinary A class shares at $7.00 per share. The terms of the shares on issue are $4.00 on application, $2.00 on allotment and a future call of $1.00 with date to be determined. If the issue is oversubscribed the directors will make a pro-rata issue of shares and the excess application money will be applied to allotment and calls before any refunds will be…

Details

In the new project, the company will buy a new machinery

Your group is working in Finance Department of a production company. Your company is considering a new investment project. In the new project, the company will buy a new machinery that enable to launch a new product. It is expected an annual sale of 20,000 products for an average price of $450 per unit for 5 years. The new investment project has the initial cost of $1,850,000, a residual value of $350,000 at the end of the project. The company will need to add $400 000 in working capital which is expected to be fully retrieved at the end of the project. Other information is available below: Depreciation method: straight line Variable cost per unit: $270 Cash fixed costs per year:…

Details

Big Bang Ltd is considering to invest in one of the two following projects

Question 1  Big Bang Ltd is considering to invest in one of the two following projects to buy a new equipment. Each equipment will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 8%. The cash flows of the projects are provided below.   Equipment 1 Equipment 2 Cost $186,000 $195,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5   86 000 93 000 83 000 75 000 55 000   97 000 84 000 86 000 75 000 63 000   Big Bang’s net income in current year is $450,000. The company maintains a capital structure of 55% in equity funding and…

Details

ABC Ltd has the following land and buildings

Question 1 ABC Ltd has the following land and buildings in its financial statements as at 30 June 2022:   Residential land, at cost 2 000 000 Factory land, at valuation 2020 1 800 000 Buildings, at valuation 2020 1 600 000 Accumulated depreciation (200 000)   At 30 June 2022, the balance of the revaluation surplus is $800 000, of which $600 000 relates to the factory land and $200 000 to the buildings. On this same date, independent valuations of the land and buildings are obtained. In relation to the above assets, the assessed fair values at 30 June 2022 are:   Residential land, previously recorded at cost 2 200 000 Factory land, previously revalued in 2020 1 400…

Details

The income statement of Price Ltd for the year

The income statement of Price Ltd for the year ended 31 December 2020, reported the following condensed information: Revenue from fees                            $600,000 Operating expenses                          360,000 Income from operations                    240,000 Income tax expense                           60,000 Net income                                       $180,000   Price’s balance sheet contained the following comparative data at December 31:   .                                                       2020            …

Details