Excel Reader Challenge winner

By J. Carlton Collins, CPA

Congratulations to Amir Melamed for submitting the best solution to the August 2014 Reader Challenge. Like many other readers, Melamed used the Excel Solver approach, but his solution bettered them all to derive a maximum portfolio value of $70,184. You can see a recap of the solutions submitted at carltoncollins.com/trades.html.  

J. Carlton Collins is a technology consultant, a CPE instructor, and a JofA contributing editor.

Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2013, 2010, and 2007 versions, unless otherwise specified.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED WHITE PAPER

Preparing the statement of cash flows

This instructive white paper outlines common pitfalls in the preparation of the statement of cash flows, resources to minimize these risks, and four critical skills your staff will need as you approach necessary changes to the process.

RESOURCES

Keeping you informed and prepared amid the COVID-19 crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.