P4_FInal_Villarreal_Report_4Sept2023
.docx
keyboard_arrow_up
School
University of Maryland, Baltimore *
*We aren’t endorsed by this school
Course
620
Subject
Finance
Date
Jun 8, 2024
Type
docx
Pages
8
Uploaded by DoctorJackal2325
1
031422
Project 4 Questions - Report Template
Instructions:
Answer the five questions below, based on the information that you developed in the Excel workbook. Provide support for your reasoning from the readings in Project 4, Step 1, and the discussion in Project 4, Step 3. Be sure to cite any sources used in proper APA (7th ed.) format. Provide a detailed response below each question. Use 12-point font and double spacing. Maintain the existing margins in this document. Your final Word document, including the questions, should not exceed 5 pages. Include a title page in addition to the five pages. Any tables and graphs you choose to include are excluded from the five-page limit. Name your document as follows: P4_Final_lastname_Report_date. You must address all five questions and make full use of the information in the Excel workbook.
You are strongly encouraged to exceed the requirements by refining your analysis. Consider other tools and techniques that were discussed in the required and recommended reading for Project 4.
2
3
1. Present-value calculations, rather than future-value calculations, are the key to analysis in the field of corporate finance. Why is this the case? Explain the importance for Largo Global Inc. (LGI) of understanding today's value of projected future revenues and/or costs. By operating with current and future value calculations, investors have the ability to calculate the worth of cash flow in a better way, which is important to the study of business finance. Current value calculations calculate the worth of future investment based on present currency, instead of the future value estimates that consider the effect of compound interest. Buyers would instead buy items immediately, a reason why the value of money is an important notion in finance (Parrino, et al, 2012). The value of the dollar tends to change often and that is something LGI should take into consideration because a business can invest the funds and produce interest. The reason for this is because interest rates are low now but will only increase
as time goes. Corporate finance decisions are contingent on applying the time value of money because investment decisions consist of associating the value of current investments to the value of future cash flows. By separating the value of assets that offer various returns, LGI can analyze the current value of expected future income or costs. Present-value estimates indicate the company's real financial situation, LGI is broadly engaged in corporate finance research. Inflation and the discount rate are taken into account in the present-value calculations, producing a current value for all cash flows available. The amount of this analysis is then used to regulate the current value of the investment, instead of the estimates of future value that rely on interest rates only and not inflation. To calculate the value of cash flow in the future, future value evaluations use the combination method. Since it predicts earnings for the future, it is less
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Please complete
arrow_forward
Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items.
arrow_forward
Please show work on how to do part 5, 6a, 6b. Thank you.
arrow_forward
Instructions
• The PowerPoint presentation must be at least 10 slides of content in length (excluding title page, introductions, graphics, and references); 10-12 point font;
double-spaced; and include a cover page, introduction, body, summary or conclusion, and works cited slides.
• Although this is not a scientific-type writing assignment and is mostly creative in nature, references are still very important. At least six authoritative, outside
references are required (only peer-reviewed resources or professional databases are acceptable). These should be listed on the last slide titled "Works Cited" or
"References," depending on the format standard used.
• All Yorkville University policies are in effect, including the plagiarism policy.
• Presentations are due during Week 10 of this course.
• This presentation is worth 100 total points (10% of your total grade). It will be graded on the quality of the presentation and the use of citations, grammar, and
bulleted items structure.…
arrow_forward
to.mheducation.com/ext/map/index.html?_con3Dcon&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%25...
5 Assignment
Saved
Help
Save & Exit
Submit
Check my work
Required information
Use the following information for the Quick Study below. (Algo) (5-7)
[The following information applies to the questions displayed below.]
f3
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the
company sells. 290 units. Ending inventory at January 31 totals 130 units.
Unit Cost
$ 2.40
2.60
Units
Beginning inventory on January 1
Purchase on January 9
Purchase on January 25
260
60
46:08
100
2.74
pok
QS 5-7 (Algo) Perpetual: Inventory costing with weighted average LO P1
nt
Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on
the weighted average method. (Round your per unit costs to 2 decimal places.)
int
ences
Weighted Average -…
arrow_forward
Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items as listed in the feedback portion of the pictures. Note that the pictures are for the same problem, I have just included the separate feedback parts for specification purposes.
arrow_forward
Open the datafile named StartSalary (attached).
Follow the instructions under “using Excel’s Descriptive Statistics Tool in Chapter 3 of textbook.
Develop Figure 3.8. Make sure to use Microsoft Excel functions to generate the descriptive statistics.
Upload the final figure showing descriptive statistics.
arrow_forward
Required information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B13 enter the formula "= B5".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them.
Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…
arrow_forward
4
arrow_forward
Info in image "ACC PT1" can be used for image "ACC PT2"
arrow_forward
The instructions for this practice worksheet are in the first picture (2 word document) - the second picture has the excel worksheet to input answers. I’m having a difficult time understanding how to do this - thank you!
arrow_forward
education.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%25..
signment i
Saved
Help
Save & E
Che
Required information
Use the following information for the Quick Study below. (Algo) (5-7)
[The following information applies to the questions displayed below.]
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the
company sells 290 units. Ending inventory at January 31 totals 130 units.
Units
Unit Cost
Beginning inventory on January 1
Purchase on January 9
Purchase on January 25
260
$ 2.40
60
2.60
100
2.74
QS 5-5 (Algo) Perpetual: Inventory costing with FIFO LO P1
Required:
Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on
the FIFO method.
og
IMG 2237.HEIC
GEO 220 World R..docx
GEO 220 Chapter..pptx
Canceled
search
Hi
99
71°F
arrow_forward
This is for accounting information system class please help me figure how to do this step in excel.add the 2021 data to the Dashboard Open the file Support_EX19_EOM5-1_2021.xlsx. Copy the values in the range C6:C19. In cell C6 of the Dashboard worksheet in the original workbook, use the Paste Link command to create external references to the values in the Support_EX19_EOM5-1_2021.xlsx workbook. Delete the unnecessary values in cells C8, C12, and C16, and close the Support_EX19_EOM5-1_2021.xlsx workbook
arrow_forward
Further info is in the attached images
For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B34 enter the formula "= B9".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50.
Thank you!
arrow_forward
Use the template attached below to complete this activity: (Videos are available in the C4 module on using the ebook + copying worksheets).
Chapter_7_Applying_Excel_template-1.xlsx
Use the data found in the template + use the additional data found in the ebook section, "Applying Excel" (p. 330 print text). All calculations should be performed within the cell using cell referencing/formulas so that I can see how you arrived at your answers! Do not use your calculator and just type in numbers!
You will submit four worksheets within your assignment file:
sheet 1 = original
sheet 2 = requirement 1 quantitative + question responses
sheet 3 = requirement 2 quantitative + question responses
sheet 4 = requirement 3 quantitative + question responses
In scenario 1, 2, and 3.... copy the original worksheet after inputting your cell formulas and change the values as indicated for each requirement. Name each tab by the question #.
Chapter 7: Applying Excel
Data…
arrow_forward
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group/
3- Homework
Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indi
Required information
[The following information applies to the questions displayed below.]
Determine the amount of the late filing and late payment penalties that apply for the following taxpayers.
As
b. Oscar filed his tax return and paid his $4,400 tax liability seven months late.
Saved
Answer is complete but not entirely correct.
Late filing and late payment penalties $ 1,100 x
arrow_forward
Please answer questions correctly
arrow_forward
Academic access to the FASB Codification is available through university subscriptions, obtained from the American Accounting Association. This subscription covers an unlimited number of students within a single institution. Once this access has been obtained by your school, you should log in to prepare responses to the following exercises.
CE1.1 Describe the main elements of the link labeled “Help, FAQ, Learning Guide, and About the Codification.”
CE1.2 Describe the procedures for providing feedback.
CE1.3 Briefly describe the purpose and content of the “What’s New” link.
arrow_forward
Write an overview of the development of IFRS.
ATLEAST GIVE 10 SENTENCES
arrow_forward
Accounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).
arrow_forward
Select the best answer for the question
13. The process of transferring the information contained in the journal to the ledger is called
A. cross-referencing
OB. balancing the accounts
OC. cross-adding
D. posting.
Mark for review (Will be highlighted on the review page)
<< Previous Question
Next Quesmon
arrow_forward
Chapter 2: Applying Excel: Excel Worksheet (Part 1 of 2)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text.
Enter formulas in the cells that contain question marks. For example, in cell B25 enter the formula "=B10".
After entering formulas in all of the cells that contained question marks, verify that the amounts match the example in the text.
Check your worksheet by changing the total fixed manufacturing overhead cost for the Milling Department in the Data area to $300,000, keeping all other data the same as in the original example. If your worksheet is operating properly, the total cost of Job 407 should now be $2,350. If you do not get this answer, find the errors in your worksheet and correct them.
You should proceed to the requirements below only after completing your worksheet.
Save your completed Applying Excel form…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardPlease completearrow_forwardPlease see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items.arrow_forward
- Please show work on how to do part 5, 6a, 6b. Thank you.arrow_forwardInstructions • The PowerPoint presentation must be at least 10 slides of content in length (excluding title page, introductions, graphics, and references); 10-12 point font; double-spaced; and include a cover page, introduction, body, summary or conclusion, and works cited slides. • Although this is not a scientific-type writing assignment and is mostly creative in nature, references are still very important. At least six authoritative, outside references are required (only peer-reviewed resources or professional databases are acceptable). These should be listed on the last slide titled "Works Cited" or "References," depending on the format standard used. • All Yorkville University policies are in effect, including the plagiarism policy. • Presentations are due during Week 10 of this course. • This presentation is worth 100 total points (10% of your total grade). It will be graded on the quality of the presentation and the use of citations, grammar, and bulleted items structure.…arrow_forwardto.mheducation.com/ext/map/index.html?_con3Dcon&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%25... 5 Assignment Saved Help Save & Exit Submit Check my work Required information Use the following information for the Quick Study below. (Algo) (5-7) [The following information applies to the questions displayed below.] f3 A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells. 290 units. Ending inventory at January 31 totals 130 units. Unit Cost $ 2.40 2.60 Units Beginning inventory on January 1 Purchase on January 9 Purchase on January 25 260 60 46:08 100 2.74 pok QS 5-7 (Algo) Perpetual: Inventory costing with weighted average LO P1 nt Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. (Round your per unit costs to 2 decimal places.) int ences Weighted Average -…arrow_forward
- Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items as listed in the feedback portion of the pictures. Note that the pictures are for the same problem, I have just included the separate feedback parts for specification purposes.arrow_forwardOpen the datafile named StartSalary (attached). Follow the instructions under “using Excel’s Descriptive Statistics Tool in Chapter 3 of textbook. Develop Figure 3.8. Make sure to use Microsoft Excel functions to generate the descriptive statistics. Upload the final figure showing descriptive statistics.arrow_forwardRequired information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…arrow_forward
- 4arrow_forwardInfo in image "ACC PT1" can be used for image "ACC PT2"arrow_forwardThe instructions for this practice worksheet are in the first picture (2 word document) - the second picture has the excel worksheet to input answers. I’m having a difficult time understanding how to do this - thank you!arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning